March 17, 2009 at 3:05 am
How to Remove Backup Schedule from SQL Server 2000 ?
I have stop the Backup Schedule from SQL Server 2000, please help me out
Thanks and Regards,
Pravin V. Kadam
March 17, 2009 at 3:16 am
It depends on how to schedule the backup.
1. If a Maintenance plan is set up for it, deleting it would stop the job.
2. If a SQL Server job is set up, then deleting that job would meet your requirements.
3. If the backup is fired from the 3rd party tool, then you should disable it.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 17, 2009 at 4:12 am
Thanks for Reply,
But we are using SQL Server 2000 Enterprise Manager to schedule the same, Please suggest the Steps to stop the database backup
Thanks and Regards,
Pravin V. Kadam
March 17, 2009 at 4:17 am
Adiga (3/17/2009)
It depends on how to schedule the backup.1. If a Maintenance plan is set up for it, deleting it would stop the job.
2. If a SQL Server job is set up, then deleting that job would meet your requirements.
3. If the backup is fired from the 3rd party tool, then you should disable it.
The steps 1 and 2 above are done using SQL Server Enterprise Manager.
Step 1 -- You can find it under "Management" --> Database Maintenance Plans
Step 2 -- You can find the jobs under "Management" --> SQL Server Agent --> Jobs.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 24, 2009 at 7:41 am
I am curious as to why you want to stop the scheduled backups.
If just a temporary stoppage, go to Enterprise Mananger - Management - Sql Server Agent - Jobs, find the job that performs the backup, right click it and select 'Disable Job'.
Steve
March 24, 2009 at 9:41 am
You can also disable the schedule by opening the job, going to the Schedules tab, editing the schedule and unchecking the "Enabled" box.
Greg
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply