InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 04:14:44 GMT20http://www.sqlservercentral.com/Forums/Topic1359786-1549-1.aspxCeating many subplan instead of configure any one of the HA method between primary & secondary server.Tue, 18 Sep 2012 01:19:32 GMTananda.murugesanhttp://www.sqlservercentral.com/Forums/Topic1359786-1549-1.aspxThanks All, will try to make a plan & move :-)Tue, 18 Sep 2012 01:03:27 GMTOnlyOneRJhttp://www.sqlservercentral.com/Forums/Topic1359786-1549-1.aspxCreate a DB maintainence plan to fulfill this1) create a subplan for full backup and schedule it to run Monday2) create a subplan for diff backup and schedule it to run from tue - sun3) create a subplan for execute T-SQL stsmt / SQL agent to restore the backups accordingly (first full, later subsequent diffrential backups) and schedule it on Sunday post step 2 completion4) create subplan for Check DB integrityMon, 17 Sep 2012 05:44:51 GMTSudhakar Vallamsettyhttp://www.sqlservercentral.com/Forums/Topic1359786-1549-1.aspxIf you're not writing your own scripts, you should look to Olla Hollengren or Michelle Ufford. Each person has a set of scripts. I think Olla's are more complete and Michelle's are easier to understand and modify.As to scheduling these events, use SQL Agent. You can create multiple jobs, each with a schedule, or you can add multiple schedules to a single job.Mon, 17 Sep 2012 04:17:55 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1359786-1549-1.aspxIf you don't want to write your own scripts, there are many available on Google and on this site. Search a little ;-)Sun, 16 Sep 2012 09:52:56 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1359786-1549-1.aspxI know how to take Full backuo & differential backup..But the problem here is how do i go and automate the below strategy?Monday - Full Backup Tuesday to sunday - Differential backupNow once this is done...I want to test restore this...Like i will restore a FULL Backup first & then only the differential backup of sunday...How do i automate this is one go :(I have got many sites but i didnt get a step by step link :(Sat, 15 Sep 2012 01:23:01 GMTOnlyOneRJ