Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Quitch
Starting Member
1 Post |
 Posted - 2008-09-24 : 06:42:54
|
I have a scheduled job which has registered several failures, all as follows:quote:
Date 23/09/2008 11:00:00Log Job History (DBA Transaction Log Backup)Step ID 1Server HOSTJob Name DBA Transaction Log BackupStep Name Backup Transaction LogDuration 00:01:34Sql Severity 16Sql Message ID 3013Operator EmailedOperator Net sentOperator PagedRetries Attempted 0MessageExecuted as user: domain\user. ...ups.vbs" "E:\MSSQL.1\MSSQL\Backup" CSD21_1100 1 //T:1800 //nologo //B [SQLSTATE 01000] (Message 0) Backup Log CSD21 E:\MSSQL.1\MSSQL\Backup\CSD21_1100_20080923.trn [SQLSTATE 01000] (Message 0) Processed 6 pages for database 'CSD21', file 'CSD21_log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP LOG successfully processed 6 pages in 0.014 seconds (3.035 MB/sec). [SQLSTATE 01000] (Message 3014) No SAN Backup [SQLSTATE 01000] (Message 0) cscript "E:\MSSQL.1\MSSQL\Backup\DeleteSurplusBackups.vbs" "E:\MSSQL.1\MSSQL\Backup" KPIMaster_1100 1 //T:1800 //nologo //B [SQLSTATE 01000] (Message 0) Backup Log KPIMaster E:\MSSQL.1\MSSQL\Backup\KPIMaster_1100_20080923.trn [SQLSTATE 01000] (Message 0) Processed 0 pages for database 'KPIMaster', file 'KPIMasterNew_log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP LOG successfully processed 0 pages in 0.003 seconds (0.000 MB/sec). [SQLSTATE 01000] (Message 3014) No SAN Backup [SQLSTATE 01000] (Message 0) ... The step failed.
My question is... what failed? Everything seems to be success until the end where a failure is logged. How can I track this back? |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2008-09-24 : 07:01:19
|
| Check the Application log in the servers Event Viewer. Usually has more details on failed backup/restore operations. |
 |
|
|
|
|
|
Scheduled job fails... where??