Backups & Restore..

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Backups & Restore..

Backups & Restore..

Rate Topic

Display Mode

Topic Options

Author

Message

OnlyOneRJ

Posted Saturday, September 15, 2012 1:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

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 Sad

I have got many sites but i didnt get a step by step link Sad

************************************
Every Dog has a Tail !!!!!

Post #1359786

Perry Whittle

Posted Sunday, September 16, 2012 9:52 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201, Visits: 11,153

If you don't want to write your own scripts, there are many available on Google and on this site. Search a little Wink

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

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1359896

Grant Fritchey

Posted Monday, September 17, 2012 4:17 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,375, Visits: 25,159

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1360075

Sudhakar Vallamsetty

Posted Monday, September 17, 2012 5:44 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, September 21, 2012 2:54 AM
Points: 91, Visits: 74

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

******* Cool