November 5, 2009 at 12:04 am
How can i create a maintanence plan in sql server 2005 in such a way that log backup should happen at every 11.00 am and 3.00 pm respectively ...
November 5, 2009 at 12:50 am
Try this using ssms
go to mangement- mp
Right click on maintenance plan - new maintenance plan
Give name to mp
On left hand side, under mp tasks select backup task
in dialog box that opens
fill out all details like backup type, name of backup, location etc and than say ok
on top right of the window under subplan click on calendar column to set schedule for it
give name to schedule
frequency daily
daily frequency
choose occurs every 1 hr starting at 11:00 AM ending at 3:00 PM
click on ok
you are done.
November 5, 2009 at 12:51 am
if you want the backup to happen only at 11:00 and than directly at 3:00 PM you need to create two schedules for mp rather than one.
November 5, 2009 at 12:58 am
sejal p gudhka (11/5/2009)
if you want the backup to happen only at 11:00 and than directly at 3:00 PM you need to create two schedules for mp rather than one.
can we put like every 4 hours from 11.00 am to 3.00 pm.so only 2 backu files will be available right?
November 5, 2009 at 2:27 am
yes u can ,there is option in schedule of job called after every ___ hour starting at and ending at.
Regards
ramu
November 5, 2009 at 4:19 am
Just curious - Why only at 11 am and 3 pm
"Keep Trying"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply