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.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 BACKUP failed
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ashrafqushta
Starting Member

Egypt
5 Posts

Posted - 06/28/2011 :  09:12:53  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Germany
8781 Posts

Posted - 06/28/2011 :  09:28:28  Show Profile  Visit webfred's Homepage  Reply with Quote
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

Egypt
5 Posts

Posted - 07/03/2011 :  11:56:30  Show Profile  Reply with Quote
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

Egypt
5 Posts

Posted - 07/03/2011 :  11:56:30  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000