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.