I want 1 backup,am getting 3; how do I stop?

  • I have a maintenance plan that gives me the only backup I need; however, I have instructed (mistakenly) a backup to take place using the generic backup menu. How can I stop this redundant backup(s) from taking place?

  • Should have created a job under SQLAgent that you can disable or delete. Names usually easy to find.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • I have used the enterprise manager -> backup database to create the backups (which I am wanting to terminate) which I have revisited, and there is no naming applied to the backup command when you create a new one, just a schedule.......

  • When I do the schedule option it adds an item to Management->SQLAgents->jobs named like so DBNAME backup which I deleted to stop this schedule otherwise you did not actually schedule, just ran. If not this then maybe I am misunderstanding you.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Thank you , this has solved my problem!

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply