How to Remove Backup

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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