failed backup

what can I look at to determine why a backup failed. I have a maintence plan that does a full backup once a week and another plan that will do a transaction log backup every day at 1am. The full backups are running fine. The daily backup of the trans l
og fails everyday. The SQL Server log does not mention the failed backup. The History of the job does say failed but gives no reason. The Server (box) has an entry in the Application Log but it is not much better; it just says failed. What can I do to
troubleshoot this?
Is your database in Simple recovery mode? You can't back up the
transactionlog in simple recovery mode, only in Bulk Logged or Full recovery
mode.
Jacco Schalkwijk
SQL Server MVP
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:8354B199-B0F2-4FFD-919B-17841BB1EF66@.microsoft.com...
> what can I look at to determine why a backup failed. I have a maintence
plan that does a full backup once a week and another plan that will do a
transaction log backup every day at 1am. The full backups are running fine.
The daily backup of the trans log fails everyday. The SQL Server log does
not mention the failed backup. The History of the job does say failed but
gives no reason. The Server (box) has an entry in the Application Log but
it is not much better; it just says failed. What can I do to troubleshoot
this?
|||Outstanding Jacco! Two out of the fourteen databases I was trying to backup the transaction log on were set to "simple". Those happen to be the two I did not make! Thanks for the tip!
|||Another thing you can do for the future is go to the Scheduled Task itself, Go to Steps and edit the Step, Go to Advanced and set an output file. This way you can always look at the file to see why something failed.
Jeff Duncan
MCDBA, MCSE+I