February 6, 2011 at 6:46 am
Hi there,
I set up a maintenance plan to backup my sql 2005 server
databases[backup all databases], I run it and nothing happens under C:
\P Files\Microsoft SQL server\MSSQL.1\MSSQL\Backup\ there are no
files.
I had errors saving the job also but eventually it did.
I am running SQL 2005 RTM 9.00.1399.06
February 6, 2011 at 7:17 am
After running maintenance plan job what is the error message encountered.
M&M
February 6, 2011 at 7:39 am
When i run it i am getting a success msg .... and the maintenance plan configuration is proper ....but it is not generating backup????????
February 6, 2011 at 7:45 am
Can you test the maintenance plan on your instance by creating one plan for a single test db and then give backup path as C:\ only.
Pls try this and revert to forum.
M&M
February 6, 2011 at 8:17 am
i had tried for a single db and the path i gave as E:\ drive but still it behaves the same.....:-)
February 6, 2011 at 9:24 am
You are running the RTM version - which had several issues with maintenance plans that have been fixed in later service packs.
Additionally, in this version you are required to have Integration Services installed. That is no longer required on the later service packs.
And finally, there was a shift in how maintenance plans are structured after SP2 which will require rebuilding any maintenance plans built prior to that version. In other words, if you build your maintenance plans on this version - then upgrade to SP4 you have to delete and recreate the maintenance plans.
My suggestions is to upgrade to the latest service pack before continuing.
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
February 7, 2011 at 6:20 am
upgrade from rtm version to sp3 and then build the maintenance plan there...
Let us know, what errors you getting this time.
Regards.
Sushant
Regards
Sushant Kumar
MCTS,MCP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply