| Author |
Topic |
|
hismightiness
Posting Yak Master
164 Posts |
 Posted - 2008-01-03 : 12:02:27
|
| I have a handful of jobs that I need to troubleshoot, but this one will hopefully give me enough insight to do the rest myself. I need to figure out why a Maintenance Plan that performs a Diff Backup on 4 databases, and then a transaction log back up on the 4 databases is failing. I just get the following error message, and I cannot tell what failed.Executed as user: <SERVER_NAME>\SYSTEM. ... 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:20:05 AM Progress: 2008-01-03 11:20:05.95 Source: {SOME_STUFF_WAS_HERE} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2008-01-03 11:20:06.35 Source: Back Up Database (Differential) Executing query "EXECUTE master.dbo.xp_create_subdir N'D:\Program F".: 100% complete End Progress Progress: 2008-01-03 11:20:06.35 Source: Back Up Database (Differential) Executing query "EXECUTE master.dbo.xp_create_subdir N'D:\Program F".: 100% complete End Progress Progress: 2008-01-03 11:20:06.37 Source: Back Up Database (Differential) Executing query "EXECUTE master.dbo.xp_create_subdir N'D:\Program F".: 100% complete End Progress Progress: 2008-01-03 11:20:06.37 Source: Back Up Database (Differential) ... The package execution fa... The step failed.How can I find out how to fix this problem? And please let me know if I am doing something wrong. (For instance, perhaps those two tasks shouldn't be together.)- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-03 : 22:17:48
|
| Any backup error in sql server log? Did you check plan's log file? |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-03 : 22:47:04
|
| for a differential to succeed, there needs to be a previous successful full backup. have you performed fulls on all your databases?-ec |
|
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2008-01-04 : 08:31:14
|
| rmiao:Where do I check the log file at?eyechart:The full backups occur on early Sunday morning. And the Diffs run throughout the week. This has ran successfully in the past. It has only began very recently. I should also mention that all the databases are NOT in Simple Recovery Mode.- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2008-01-04 : 10:06:47
|
| The following information may or may not be useful in helping me:I have noticed that there is a file system back up (ntbackup) occurring during some of the same hours that the SQL Jobs are running. In the event log, I see the folowing message after the file system backup begins to execute:"I/O is frozen on database model. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup."However, one of the Diffs fails before the backup begins.- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2008-01-04 : 11:04:37
|
| rmaio:If you are talking about the Log Viewer, my error is in the original post above.- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-04 : 23:53:19
|
| Plan log file is not log viewer, it logs all messages produced by the plan and you specify log file path when create plan. |
|
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2008-01-07 : 08:41:46
|
quote:
Originally posted by eyechart
check this article out http://support.microsoft.com/kb/903643-ec
Thanks... So that is an expected message, and ntbackup is not the problem (so far).Can anyone tell me where to find the plan log file?- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 22:53:13
|
| Did you check your maintenance plan? Default log file path is sql server's log file path. |
|
|
|
|
Need Help Troubleshooting Diff BackUp Job