March 27, 2008 at 3:08 pm
Hi I am using a SQL server 7.0 and i have set up a maintenance plan to do backups twice a week. Its not working!
Help
Please
March 27, 2008 at 4:20 pm
we are going to need more info than that to be able to help you. Whats the error message?
common cause for maint plan job not working is SQL not recognizing the owner of the jobs it creates. Check the job history for the maint plan jobs, change the owner to an explicitly defined login with sufficient rights to run the job if necessary (usually sa)
---------------------------------------------------------------------
March 28, 2008 at 8:51 am
I am not getting any error massages. I have the rights to run the job. Let’s say I want to backup one database. I right click on the database go to all tasks and than backup database. Once I change the destination and set up a schedule I click OK and it looks like it saved it, but when I go back it shows the old properties.
Last night I tried to backup the database by selecting a schedule type one time only and that seemed to work.
Why am I unable to create the schedule to back up the database?
I tried backing it by scheduling a maintenance plan, but it is not backing it up.
Thank you
March 28, 2008 at 9:10 am
If you have tried to back up the database via a maintenance plan there must be an agent job. What does the 'view job history' say happened. does the job show as succeeded or falied?.
When you set up the maintenance plan did you schedule a run time?
---------------------------------------------------------------------
March 28, 2008 at 10:52 am
You are not setting up a maintenance plan if you right click the database. While that might make sense, what you are setting up is an ad hoc backup.
go to the Maintenance plans folder in SSMS to set up a maintenance plan.
March 28, 2008 at 10:57 am
oh, I read that as he'd tried both.........that never ocurred to me!
---------------------------------------------------------------------
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply