Backup database problems
-
Hi,
I used for automatically backup databases the wizard Database Maintenance Planner (talking about Sql Server 2000).
Is it ok? I mean it seemed to me the easiest way to do it, but do I have an efficient backup for my databases?
Anyway, I have two problems:
1.I want to store informations in msdb database, but, when I delete a job I have to delete manually from sysdbmaintan... tables in msdb.
Is any way to automatically happen this task? Or maybe I am doing something wrong?
2.I created the jobs using this wizard, the job is enable (Enable checkbox is checked) but I noticed that the backup isn't done untill I specific choose "Start job". What am I doing wrong?Or it is some extra step to do?
Daniela
-
Using the Database maintenance plan wizard is an effective way to schedule backups.
1. If you create the job using the DB Mainenance plan wizard, make changes to the job using the wizard. This should keep your MSDB in sync with your maintenance plans. I would not recommend manually deleting anything from any of the system databases.
2. Check the schedule on the job. The default schedule is once a week on Sunday morning. Odds are, you just need to alter the job schedule to run daily.
-
Thanks, on point 2 I saw the error - I didn't set well the period I wanted.
On point 1 one more question: after I use the wizard, I see the jobs on Job section. But, if I want to re-run the wizard, to make changes on the jobs, or delete the jobs, I don't have an option like "Choose an existing job" or something like it. How can I see through the wizard an existing job, to modify it?
Daniela
-
Just double-click on the Maintenance plan in the Database Maintenance Plans window and you will be able to edit the activities that that plan will perform. Doing this will automatically add/remove the jobs from the SQL Server Agent>>Jobs Window.
-
Thank you, it worked well
Daniela
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply