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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 BACKUP failed

Author  Topic 

ashrafqushta
Starting Member

5 Posts

Posted - 2011-06-28 : 09:12:53
Dear All
I have a sql 2008 server with maintenance plan included daily Full Database backup it worked well long time but suddenly i got an error with Event ID= 3041 with this description

BACKUP failed to complete the command BACKUP DATABASE slo_billing_sysdate. Check the backup application log for detailed messages.

Please tell me how to solve this problem and where is backup application log
Many Thanks
Eng.AShraf

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-06-28 : 09:28:28
From sqlservercentral.com:
check the backup application log -actually means for you to check the Windows Event Viewer Logs. The application log and the SQL Server Error Log are 'tied' together with the application log usually showing more details.
Also, look at the entries above and below that one in the SQL Server Error log.
A lot of times this error is due to drive space issues.

http://www.sqlservercentral.com/Forums/Topic452567-357-1.aspx#bm452582


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

ashrafqushta
Starting Member

5 Posts

Posted - 2011-07-03 : 11:56:30
Many Thanks - I found the problem
Our mantenance paln take Full databases backup and some of databases was in offline mode so this error was generated
many Thanks again
Ashraf
Go to Top of Page

ashrafqushta
Starting Member

5 Posts

Posted - 2011-07-03 : 11:56:30
Many Thanks - I found the problem
Our mantenance paln take Full databases backup and some of databases was in offline mode so this error was generated
many Thanks again
Ashraf
Go to Top of Page
   

- Advertisement -