Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backups & Restore.. Expand / Collapse
Author
Message
Posted Saturday, September 15, 2012 1:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
I 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 backup

Now 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








************************************
Every Dog has a Tail !!!!!
Post #1359786
Posted Sunday, September 16, 2012 9:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 6,737, Visits: 14,371
If you don't want to write your own scripts, there are many available on Google and on this site. Search a little

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1359896
Posted Monday, September 17, 2012 4:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:12 AM
Points: 14,196, Visits: 28,523
If 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.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1360075
Posted Monday, September 17, 2012 5:44 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 3, 2013 12:38 AM
Points: 91, Visits: 77
Create a DB maintainence plan to fulfill this
1) create a subplan for full backup and schedule it to run Monday
2) create a subplan for diff backup and schedule it to run from tue - sun
3) 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 completion
4) create subplan for Check DB integrity


*******
Sudhakar
Post #1360123
Posted Tuesday, September 18, 2012 1:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
Thanks All, will try to make a plan & move







************************************
Every Dog has a Tail !!!!!
Post #1360585
Posted Tuesday, September 18, 2012 1:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:55 PM
Points: 1,076, Visits: 3,054
Ceating many subplan instead of configure any one of the HA method between primary & secondary server.
Post #1360591
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse