January 7, 2010 at 3:58 pm
Hi ,
We have SQL Server 2000 32 bit with SP3 and therse maintenance paln job running daily for full backups and it's running fine i.e I did not see any errors in the 'view job history' But in the error log, I can see the below error daliy when the backup job runs
BACKUP failed to complete the command EmptyTransactionLog;1
Could you please advice what this error referring to. (all databases are in Simple recovery mode)
thanks
January 7, 2010 at 4:05 pm
If you have databases in simple mode, you do not need log backups. The checkpoints should mark the log as free. I'm not sure why you see this error in the error log.
Can you post the entire message from the Error log and then what backup command you are using?
January 7, 2010 at 6:19 pm
I have verified again that all databases are in Simple recovery mode and NO transaction log backup is scheduled. We are using Maintenance paln for full backup. Below is the info from error log:
2010-01-05 02:00:03.73 backup Database backed up: Database: master, creation date(time): 2009/12/09(18:56:14), pages dumped: 1859, first LSN: 235:137:1, last LSN: 235:139:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\master\master_db_201001050200.BAK'}).
2010-01-05 02:00:04.70 backup Database backed up: Database: model, creation date(time): 2000/08/06(01:40:52), pages dumped: 93, first LSN: 25:295:1, last LSN: 25:297:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\model\model_db_201001050200.BAK'}).
2010-01-05 02:00:09.15 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 3219, first LSN: 949:170:1, last LSN: 949:174:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\msdb\msdb_db_201001050200.BAK'}).
2010-01-05 02:03:16.98 backup Database backed up: Database: Mydb, creation date(time): 2005/06/08(13:08:20), pages dumped: 190691, first LSN: 14883:42:1, last LSN: 14883:48:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Mydb\Mydb_db_201001050200.BAK'}).
2010-01-05 02:05:06.52 backup Database backed up: Database: Mydb_2006, creation date(time): 2006/04/28(14:44:11), pages dumped: 95523, first LSN: 9214:42:1, last LSN: 9214:45:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Mydb_2006\Mydb_2006_db_201001050203.BAK'}).
2010-01-05 02:06:33.04 backup BACKUP failed to complete the command EmptyTransactionLog;1
2010-01-05 02:06:48.96 backup Database backed up: Database: Mydb_2007, creation date(time): 2007/04/18(14:24:50), pages dumped: 94155, first LSN: 7065:42:1, last LSN: 7065:45:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Mydb_2007\Mydb_2007_db_201001050205.BAK'}).
2010-01-05 02:09:17.77 backup Database backed up: Database: Mydb_Control, creation date(time): 2006/04/28(14:23:03), pages dumped: 139915, first LSN: 4667:45:1, last LSN: 4667:49:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Mydb_Control\Mydb_Control_db_201001050206.BAK'}).
2010-01-06 02:00:03.76 backup Database backed up: Database: master, creation date(time): 2009/12/09(18:56:14), pages dumped: 1859, first LSN: 235:142:1, last LSN: 235:144:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\master\master_db_201001060200.BAK'}).
2010-01-06 02:00:04.68 backup Database backed up: Database: model, creation date(time): 2000/08/06(01:40:52), pages dumped: 93, first LSN: 25:300:1, last LSN: 25:302:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\model\model_db_201001060200.BAK'}).
2010-01-06 02:00:08.99 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 3219, first LSN: 949:316:1, last LSN: 949:319:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\msdb\msdb_db_201001060200.BAK'}).
2010-01-06 02:03:23.74 backup Database backed up: Database: Mydb, creation date(time): 2005/06/08(13:08:20), pages dumped: 190691, first LSN: 14883:51:1, last LSN: 14883:53:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Mydb\Mydb_db_201001060200.BAK'}).
2010-01-06 02:05:13.20 backup Database backed up: Database: Mydb_2006, creation date(time): 2006/04/28(14:44:11), pages dumped: 95523, first LSN: 9214:48:1, last LSN: 9214:50:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Mydb_2006\Mydb_2006_db_201001060203.BAK'}).
2010-01-06 02:06:32.99 backup BACKUP failed to complete the command EmptyTransactionLog;1
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply