Enabling Transaction Log Back Ups



  • 1. Setup remote connect to MSDE 2000?
    Hi, I hope I have the right place. Suggestions on appropriate newsgroup are welcome. I have installed MSDE 2000 on a "server" (Windows 2000 Pro) for the purpose of testing "Axosoft OnTime 3". It works fine on the server machine, but I can not connect to MSDE from a client machine (Windows XP Pro). Before starting to flame me for talking about an inappropriate product in the newsgroup (OnTime 3), the problem is that I can't connect to MSDE 2000 using the link functionality of Microsoft Access, either. I've reviewed posts on this newsgroup with similar problems and they refer to configuration utilities, but don't say anything about how to get them. Any thoughts would be appreciated. Tony Duncan Geotools
  • 2. restore master without sqlserver running?
    due to a snafu on the reconfiguring of a server, a raid with the database files was reformatted. unfortunately, our backup software does not backup the db files since they are in use at the time of backup. now, sqlserver won't start because there is no master.mdf file. i do have a backup of the master db. is there any way i can restore that without sqlserver running? or will i have to reinstall sqlserver and then restore master along with all the other db's?

Re: Enabling Transaction Log Back Ups

Postby Flicker » Sat, 20 Sep 2003 03:24:19 GMT

if the recovery option is SIMPLE then you can't do a trans log backup.

Similar Threads:

1.Full back ups and transaction logs

Running 2005 with sp2.  It seems that when running a full back up set as a 
maintenace plan  the transaction logs are filling up and do not shrink back.  
The database is set to FULL recovery.   Can some please assist me thank you 

2.Log File Full -> Back up Transaction Log


I get the following error message occassionally,
"The log file for database 'TSBASE' is full. Back up the transaction log for 
the database to free up some log space."

I'll backup the transaction log, and the database immediately. But after a 
while (a few weeks), the error comes out again. 

Why is there such an error? It seems like no matter how large I assign the 
size of the transaction log to be, I'll still get this error one day. How 
occassionally do I need to backup the transaction log? Is backing up the 
transaction log the only solution? Will it come to a day whereby the log file 
gets really so full that even backing up won't solve the problem?

Thank you in advance. 

3.Back up the transaction log for the database to free up some log s

I have a server with 80 GB free space.  Logfile for the database is set to 
autogrow (10%), unrestricted.  The log file itself is right now about 25 MB.

This message can't be accurate, so I'm wondering what could cause this.  
There was no activity that would cause the logfile to grow, certainly not 80 

I've seen this intermittently, no standard, easily reproducible cause.  In 
this particular case, I was doing a defrag of the file system, and trying to 
parse a query in an SSIS package.

I've googled this (of course) and found a few people who've seen similar 
error messages with large amounts of free space, but nothing conclusive.


4.enable advanced performance - no UPS


I just enabled disk cache and advanced performance on our SQL-server 
machine's disks. The computer doesn't have any UPS, so I guess I could be in 
trouble if there is a power outage. But how serious is this? The machine is 
a dedicated sql server which mainly serves as a development machine. We do 
however store some license information in the sql-server, that database is 
however backed up on a regular basis.

Which are the worst case scenario?
- Re-install Win. Serv. 2003?
- Re-install SQL-server?
- Some corrupted/lost datarows in the database if someone worked on it when 
the outage happened?
- Complete loss of all data?
- Unusable database files?



5.Question about Back ups

I have a production server that has a lot of data changes through out the 
day. I do one full back up at night and do hourly log back ups through out 
the major part of the day. 

My question is when I do the full back up does it back up the log as well 
and does it purge the data in the log? Also, when I do hourly log back ups 
should I append the most recent hourly log back up or overwrite it? Not sure 
if the log purges when you do a back up?

Thanks for your help?


6. q: enabling transaction logs

7. enabling transaction logs

8. Transaction Log Backup Not Enabled



Who is online

Users browsing this forum: No registered users and 99 guest