September 15, 2012 at 1:23 am
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 !!!!! :-D
September 16, 2012 at 9:52 am
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" 😉
September 17, 2012 at 4:17 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 17, 2012 at 5:44 am
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:
Sudhakar
September 18, 2012 at 1:03 am
Thanks All, will try to make a plan & move 🙂
************************************
Every Dog has a Tail !!!!! :-D
September 18, 2012 at 1:19 am
Ceating many subplan instead of configure any one of the HA method between primary & secondary server.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply