Question
August 9, 2007 at 06:11 AM
nishi57

SQL Backup generates an error after backup

by nishi57 . Updated 19 years, 2 months ago

I am not sure as to why this is happening, but would like if someone can point me in the right direction or help me fix this error message.

It is happening with only one of my SQL database, I have setup a “Database Maintenance Plan” for the Database and it’s Transaction logs to get backed up. It takes a complete backup of the database which occurs every week on Sunday at 2:00 AM, and the Transaction Log backup happens from Monday through Saturday at 12:00 AM.

This is the error message that I am getting –

“Backup failed to complete the command BACKUP LOG (R1MaxCRM) to DISK = N’D:\SQL BACKUPS\R1MaxCRM\R1MaxCRM_tlog_200708080000.TRN’WITH INIT, NOUNLOAD , NOSKIP , STATS = 10 , NOFORMAT.”

Any help will be greatly appreciated.

Thanks.

This discussion is locked

All Comments