November 29, 2008 at 3:48 am
Hi
I have a problem i create a device backup for my database, and i tried to make a maintainable plan to make full back up on Sunday. but it gives the error every time when the plan is occur...
November 29, 2008 at 4:11 am
The error message would be really useful in trying to help you. Can you post it please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 6:00 am
HI This is the error log :
11/29/2008 15:53:11,Differential_BackUp.Subplan_1,Error,0,GIS-SV01,Differential_BackUp.Subplan_1,(Job outcome),,The job failed. The Job was invoked by User SLEMANI-GIS\administrator. The last step to run was step 1 (Subplan_1).,00:00:05,0,0,,,,0,,,
November 29, 2008 at 9:20 am
Right-click on the Maintenance plan and choose View History from there. This will show you which step failed and you should be able find the actual error message.
Also - check the logs (SQL Server and Windows) for any error messages.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
November 29, 2008 at 9:34 am
Ok, that's not of much help. I hate the way the errors are cut off.
See if you can find the job that runs the maint plan. Open the job, find the job step that's failing and open that. Go to the advanced page and where it says Output file, specify a text file. The maint plan will then post the entire error message into that file. That should be a tad more useful.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 10:57 pm
This the full error message:
Message
Executed as user: GIS-SV01\SYSTEM. ...on 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:41:08 AM Error: 2008-11-30 08:41:10.11 Code: 0xC0010018 Source: Back Up Database Task Description: Error loading a task. The contact information for the task is "Back Up Database Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. End Error Error: 2008-11-30 08:41:10.11 Code: 0xC0010018 Source: Back Up Database Task 1 Description: Error loading a task. The contact information for the task is "Back Up Database Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. End Error Progress: 2008-11-30 08:41:11.55 ... The package execution fa... The step failed.
November 30, 2008 at 2:41 am
Hmm. That almost looks like the main plan's corrupted. Can you try recreating it? Can you also try backing up to that device not using the maint plan?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 30, 2008 at 3:14 am
Yes of course I can make aback up by R.Clicking on the backup device very easy..... and I recreate the maintain plan for backing up and using the backup device it gives the same error.....
November 30, 2008 at 3:51 am
Hmmm.....
I know there were some issues with the maintenance plans in SP2. They were fixed in a re-release of SP2, but you've got the initial release of the service pack. Do you have a test server that's exhibiting the same problems? Somewhere you can test installing one or the cumulative updates and see if it resolves the problem?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 30, 2008 at 10:47 am
nbaghm (11/29/2008)
This the full error message:Message
Executed as user: GIS-SV01\SYSTEM. ...on 9.00.3042.00 for 32-bit
Okay - this version is the initial SP2 that was released. You should be on a minimum of 9.00.3054 which is the patched version of SP2 that fixed the maintenance plan issues.
However, the error that you are getting does not appear to be a problem that we saw with that version. It really looks like the type of problem you would see if you are creating the maintenance plan using un-patched client tools.
Verify the version of the client tools you are using - and see if you can upgrade to at least 9.00.3054.
Review the following article for more information on SP2 versions:
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 3, 2008 at 3:25 am
Thank you very much for your replay..
I downloaded the update service pack, but still i have the problem, and even i can not make a backup plan even without using the backup device.....
I must make a backup manually....
December 3, 2008 at 4:51 am
Did you apply the patch to both the server and the machine you're running the client tools from?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2008 at 8:16 am
yes i applied the patch,but it not solve the problem....
December 3, 2008 at 8:23 am
Please run SELECT @@version on the server and post the results. Please go to the help menu in management studio, select About Management studio and copy the version listed there for management studio and past into a reply.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2008 at 8:34 am
Can you avoid a backup device and just back up to disk?
Viewing 15 posts - 1 through 15 (of 32 total)
You must be logged in to reply to this topic. Login to reply