January 30, 2008 at 7:49 am
I set up schedules for backups to run every night on each database. Then it was decided to use the database maintenance plan to do this instead. The reason was because the append option was making the file too large but we also didn't want to lose the option of backing up to a certain previous date. My problem is that I can't figure out how to stop the scheduled backups from running; it's creating two backup files each night.
January 30, 2008 at 5:24 pm
You should be able to disable the schedules for the jobs. Open a job in Enterprise Manager, click on the "Schedules" tab, edit the schedule and uncheck the "Enabled" box.
If you don't need the old sceduled backup jobs anymore, just delete them. A job worn't run if it doesn't exist. 🙂
Greg
February 1, 2008 at 1:03 pm
Thank you very much. I didn't know about the Jobs folder under the SQL Server Agent. Its all very new to me.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply