November 16, 2011 at 5:17 am
My backup failed last night. This is what I get in then log:
PRODDB Executing query "BACKUP DATABASE [PRODDB] TO DISK = N'U:\\PRODDB".: 50% complete End Progress Progress: 2011-11-16 00:51:00.10 Source: Back Up PRODDB Executing query "declare @backupSetId as int select @backupSetId =".: 100% complete End Progress Progress: 2011-11-16 00:51:00.16 Source: History Cleanup Task Executing query "declare @dt datetime select @dt = cas. The step failed.
I am new to SQL Server. What does the above mean. Did the backup failed on the last step - Cleanup task?
November 16, 2011 at 6:03 am
ashanair70 (11/16/2011)
My backup failed last night. This is what I get in then log:PRODDB Executing query "BACKUP DATABASE [PRODDB] TO DISK = N'U:\\PRODDB".: 50% complete End Progress Progress: 2011-11-16 00:51:00.10 Source: Back Up PRODDB Executing query "declare @backupSetId as int select @backupSetId =".: 100% complete End Progress Progress: 2011-11-16 00:51:00.16 Source: History Cleanup Task Executing query "declare @dt datetime select @dt = cas. The step failed.
I am new to SQL Server. What does the above mean. Did the backup failed on the last step - Cleanup task?
Looks like the backup went fine and the Cleanup got error.
You can log to a file or a table to capture more messages and investigate what goes wrong during the cleanup task.
-- Gianluca Sartori
November 16, 2011 at 10:29 am
It looks like you are using maintenance plans to do this process so you should look in the maintenance plan logs for better details a query like this:
SELECT
SL.task_detail_id,
SL.plan_id,
SL.subplan_id,
SL.start_time,
SL.end_time,
SL.succeeded,
SL.logged_remotely,
SL.source_server_name,
SL.plan_name,
SL.subplan_name,
SS.subplan_name,
SS.subplan_description,
SL2.line1,
SL2.line2,
SL2.line3,
SL2.line4,
SL2.line5,
SL2.server_name,
SL2.start_time,
SL2.end_time,
SL2.error_number,
SL2.error_message,
SL2.command,
SL2.succeeded
FROM
dbo.sysmaintplan_log AS SL
JOIN dbo.sysmaintplan_subplans AS SS
ON SL.plan_id = SS.plan_id AND
SL.subplan_id = SS.subplan_id
JOIN dbo.sysmaintplan_logdetail AS SL2
ON SL.task_detail_id = SL2.task_detail_id
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 16, 2011 at 10:59 am
Is it possible to run the History Cleanup task alone to troubleshoot? How do I log to a file?
November 16, 2011 at 11:28 am
ashanair70 (11/16/2011)
Is it possible to run the History Cleanup task alone to troubleshoot?
Sure. Open the maintenance plan, right click the cleanup task and select "Execute Task".
How do I log to a file?
It's an option in the SQLServer Agent Job Step properties window, "Advanced" tab.
-- Gianluca Sartori
November 16, 2011 at 11:58 am
Maintenance plan design window is the one that appears when I double-click this maintenance plan.
I don't have an Execute command in the menu if I right click the History Cleanup Task or any other task on the maintenance plan design window.
November 16, 2011 at 2:58 pm
You're right, sorry for suggesting a wrong solution.
I was thinking about old DTS packages.
You have no other change than running the whole maintenance plan, then.
You should see the log file path in "reporting and logging", near "manage connections" on the toolbar.
-- Gianluca Sartori
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply