Need to stop Multiple database backups.. Help!!!

[tecknogeek]

Hello,
Multiple schedule database backups are running on a single database. Every morning I look in the backup folder and there are several backups that have ran. one at 9:30pm another at 3:00 am etc...

Looks to me someone has ran the database maintenance planner wizard serveral times without knowing they already had a scheduled backup plan going.

I need to reduce this to one scheduled backup. Can someone tell me how to remove or stop the others using Enterprise Manager.

Thank you,
William

 

[SQLBill]

In Enterprise Manager, drill down to Management, then Jobs. Look through the job list to find the backup jobs.

Warning: Do you know what type of backups these are? They could be LOG backups, which should be done frequently.

-SQLBill

Posting advice: FAQ481-4875