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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-04 : 13:56:51
|
| swaprakash writes "Dear All, At the time of administrating Datasbse server I found one warnings in Application log file of NT Event viewer. Warning is due to failure of Transaction log Backup job i.e. "Transaction Log Backup Job for DB Maintenace Plan . Example:Date / Time : 2/26/02 4:00:21 PMEvent ID: 208Warning: Sql Server shedule Job 'Transaction Log Backup Job for DB Maintenace Plan 'Maintenance Plan1' ' (0x445F7859B3C9D51188400D0B74453DD) - Status Failed - Invoked on 2/26/02 4:00:00 AM : The job failed. The Job was invoked by Schedule 21 (Schdule 1). The last step to run was step 1 (Step 1). The above error I don't found after or before the above specified time in the Application Log file of the database server. Please let me know that why this error is comming. Thanks Regards Swaprakash Dash" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-04 : 14:44:52
|
| Please look at the job history, and check the option for show step details. That should give more information.You might also want to look in your sql error log and see if anything is logged at: 2/26/02 4:00:21 -Chad |
 |
|
|
|
|
|
Transaction log backup warning