August 27, 2007 at 8:33 pm
Hello,
When I create a Maintenance Plan which is to backed up the Transaction Log every 12:00 in midnight. Every morning I'll check the sql server agent in our server, I found out that the agent is Failed. When I checked the log files written in C:\ drive. Listed below the errors found in log files:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'OSMSQL5' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'Backup 1145 - Transaction Log' on 27.08.2007 00:00:02
[1] Database ASPState: Transaction Log Backup...
Destination: [C:\Backup\ASPState_tlog_200708270000.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[2] Database ASPState: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Backup can not be performed on database 'MNHUMAN'. This sub task is ignored.
[3] Database mnhuman2: Transaction Log Backup...
Destination: [C:\Backup\mnhuman2_tlog_200708270000.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[4] Database mnhuman2: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Backup can not be performed on database 'OSM_Crewing'. This sub task is ignored.
Backup can not be performed on database 'OSM_Log'. This sub task is ignored.
[5] Database OSM_Payroll: Transaction Log Backup...
Destination: [C:\Backup\OSM_Payroll_tlog_200708270000.TRN]
** Execution Time: 0 hrs, 0 mins, 2 secs **
[6] Database OSM_Payroll: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[7] Database OSM_Users: Transaction Log Backup...
Destination: [C:\Backup\OSM_Users_tlog_200708270000.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[8] Database OSM_Users: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[9] Database OSM_Web: Transaction Log Backup...
Destination: [C:\Backup\OSM_Web_tlog_200708270000.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[10] Database OSM_Web: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[11] Database Reporting: Transaction Log Backup...
Destination: [C:\Backup\Reporting_tlog_200708270000.TRN]
** Execution Time: 0 hrs, 0 mins, 1 secs **
[12] Database Reporting: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
Deleting old text reports... 2 file(s) deleted.
End of maintenance plan 'Backup 1145 - Transaction Log' on 27.08.2007 00:00:05
SQLMAINT.EXE Process Exit Code: 1 (Failed)
Thanks.
Regards,
Carmen
August 28, 2007 at 12:39 am
Carmen,
the most likely reason is that the databases which fail are in SIMPLE recovery mode. Either change it to FULL or exclude them from the transaction log backup.
Markus
[font="Verdana"]Markus Bohse[/font]
August 28, 2007 at 7:50 am
Carmen,
You can check what recovery mode you are in with
SP_HELPDB [database name]
Note, that even if you change it to FULL or BULK recovery mode, you will have to perform a full backup in order to be able to perform log backups later.
Regards,
Andras
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply