July 26, 2008 at 12:18 am
i have created two full backup schedule one at 1.30 pm and one at 1.30 am in management plan task. Now i want to stop full backup happening at 1.30 pm as it occupies lot of disk space.
to stop this schedule i have enter the end date in duration option bust still the backup is happening.
pls advice.
Ajay
July 26, 2008 at 10:16 am
Remove a schedule from the maintenance plan or disable the job in the SQL Agent list.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 27, 2008 at 4:59 am
right click on maintanence plan, select modify option & right click on the maintanance plan task that opens on Visual Studio & select the disable option. Hope this helps
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply