SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' (0xC83E14E2E989D147985A1AF15BD81A84) - Status: Failed - Invoked on: 2003-12-29 23:00:00 - Message: The job failed. The Job was invoked by Schedule 6 (Schedule 1). The last step to run was step 1 (Step 1).
The DataBase backup finishes. The Transaction does not. Can't find
anything wrong. Help! Thanks...dmc
Originally posted by Brett Kaiser
Expand it to show step details...
Thanks...expanding to show details gave the error to research.
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed
found that since I was backing up the MASTER database, you can
not do a backup of Transcation log. Alter the DB plan to take out
Transcation log backup and have made this a seperate/indivisual job.
All is good...
Thanks to all for your input. This was my first post to the forum. I look forward to returning...dmc