January 13, 2003 at 1:08 am
On a database maintenance plan, the backup of the transaction log is zero bytes in length. For several months it has been running ok and all of a sudden it has become zero length. All of the logs show a correct backup and the log is 4gb in size. Any ideas ?
January 13, 2003 at 9:55 am
In wich recovery mode your database is?
January 13, 2003 at 10:21 am
Are you appending to one file or making a new one each time?
Steve Jones
January 13, 2003 at 11:09 am
A new file is created each time. It is as part of a maintenance plan. The plan has the following set for the t log
Backup of the transaction log
Verify is on
Backup to disk
Remove files older than 4 days
The log is currently 3.31gb and the database is 11.4gb
January 13, 2003 at 12:12 pm
Try running the backup yourself and see what happens with BACKUP LOG TSQL process. Also, check the Event Viewer logs to see if anything may have been reported to the OS, backup usually does if an error occurrs.
January 13, 2003 at 2:27 pm
I have had that problem when my database recovery mode gets set to simple from full.
January 15, 2003 at 1:46 am
The recovery mode is Bulk Logging.
I will try to run a manual backup later on today 15th Jan and come back with the results.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply