SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 BACKUP failed to complete the command BACKUP LOG m
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

poratips
Posting Yak Master

104 Posts

Posted - 09/30/2013 :  11:21:52  Show Profile  Reply with Quote
Hi,
I am getting following error message daily into my error log.
I am running FULL Backup, Diff Backup an T-Log Backup.
This message is every morning early I see and looks like during same time my T-log backup job also running.
I have also checked that MSDB is in SIMPLE recovery mode and it's not part of my T-Log back up, it's only part of FULL BAckup - weekly.


ERROR:
BACKUP failed to complete the command BACKUP LOG msdb. Check the backup application log for detailed messages.

tkizer
Almighty SQL Goddess

USA
35934 Posts

Posted - 09/30/2013 :  11:59:57  Show Profile  Visit tkizer's Homepage  Reply with Quote
Something is wrong with your log backup job then. Is it a maintenance plan or custom code? Recreate it if it's a maintenance plan.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

poratips
Posting Yak Master

104 Posts

Posted - 09/30/2013 :  13:44:06  Show Profile  Reply with Quote
Thanks Tara.
This is a SSMS Maintenance Job.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000