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.
| Author |
Topic |
|
poratips
Posting Yak Master
105 Posts |
 Posted - 2013-09-30 : 11:21:52
|
| 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
38200 Posts |
Posted - 2013-09-30 : 11:59:57
|
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-09-30 : 13:44:06
|
| Thanks Tara.This is a SSMS Maintenance Job. |
|
|
|
|
|
|
BACKUP failed to complete the command BACKUP LOG m