SQL Server Performance

Remove Backup Schedule

Discussion in 'General DBA Questions' started by fauzanf, Oct 6, 2009.

  1. fauzanf New Member

    Dear My Friends,
    I have a question...
    I just assign a backup schedule to one of database in my server...
    How can i remove the schedule from the database....?
    Need advice please....

  2. Madhivanan Moderator

    You can disable the job that is doing the scheduled backup
  3. fauzanf New Member

    If you don't mind...
    Could you give a step by step please...? [:)]

  4. Luis Martin Moderator

    1) Open Entreprise Manager.
    2) Connect to sql server.
    3) Expand Manager.
    4) Expand SQL Agent.
    5) Expand Jobs.
    6.1) Right click on the backup job. Choose Disable. Or,
    6.2) Right click on the backup job. Choose Delete. Or,
    6.3) Double click on the backup job. Schedule tab. Disable Schedule option.

  5. fauzanf New Member

    Thanks very much, really help me... [8-|]

Share This Page