How to remove a scheduled backup task from SQL Server 2005

• rohan.dwyer

  SSC Journeyman

  Points: 83

  More actions

  May 18, 2009 at 8:36 pm

  #209533

  Hi all,

  I am completely new to SQL Server 05 and have been made responsible for backing it up. I'm more of a sys admin type person, not a DBA!

  I hope that someone can point me in the right direction. Basically I have created a backup schedule as a task using this guide:

  (http://support.microsoft.com/kb/930615)

  I didn't configure it properly before I ran the task and it executed and disappeared from the screen. I have tried going back into tasks > backup but can't work out how to delete this scheduled task i made.

  I want to instead make use of a maintenance plan as my version of sql server 2005 supports this method and it seems better (http://cherupally.blogspot.com/2009/04/schedule-daily-backup-for-sql-server_27.html)

  Any help would be appreciated. Thanks 🙂

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  May 18, 2009 at 9:02 pm

  #996721

  The Job was created in a different place.

  Expand SQL Server Agent. Look in the Jobs folder. Right Click the Job and select Delete.