July 10, 2014 at 1:27 am
Hi Experts,
Am using SQL server 2008.
My Backup Strategy is :
>Weekly Full Backup
>Daily Differential Backup and
>Hourly Log backup.
Now My Question is ,If the 1st,2nd ,3rd and 4th days Differential backups got corrupted.
I have Recent Fullback backup and 5th ,6th days Differential backups with all log backups ,In this scenario how can i restore upto the till date,Which backups i have to restore from all the Backups(Full,Diff and Log) .
Please give me resolutions for this..
Regards
Jagadeesh....
Regards
Chowdary...
July 10, 2014 at 2:21 am
The full, the latest diff, all the logs since that diff. The fact that earlier diffs are corrupt is irrelevant.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 10, 2014 at 2:48 am
Thank you Gila for giving the reply @ GilaMonster
If All the Differential Backups got corrupted means in that case what will be the resolution to restore the data.
Regards
Jagadeesh...
Regards
Chowdary...
July 10, 2014 at 4:47 am
Chowdary's (7/10/2014)
Thank you Mr.Gail Shaw for giving the reply.If All the Differential Backups got corrupted means in that case what will be the resolution to restore the data.
Regards
Jagadeesh...
If all the differential backups were corrupt, assuming you had all the log backups available, you could still restore the full backup and then all the log backups.
I'm not sure why you're so focused on the differentials as such a huge vulnerability to corruption. Frankly the FULL backup is the one to worry about. Without that, nothing else will work.
"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
July 10, 2014 at 5:20 am
Chowdary's (7/10/2014)
Thank you Mr.Gail Shaw...
😀
qh
July 10, 2014 at 5:30 am
The same user has thanked me as a man too :-D. It's just nice when people say thank you.
July 10, 2014 at 5:50 am
Beatrix Kiddo (7/10/2014)
The same user has thanked me as a man too :-D. It's just nice when people say thank you.
Indeed, no offense intended.
qh
July 10, 2014 at 6:46 am
Thank Alllllllllllllllllllllllllllllllllll......
I think this is ok for all of us if i say like Thank you all...
But one thing whenever i post a query i get the answers soon from Mrs./Miss GilaMonster and Mr.Grant ,So i always thanking them by the Name...
Thats y i mentioned My Favorite Name ..:-)
Regards
Chowdary...
July 10, 2014 at 7:52 am
Chowdary's (7/10/2014)
Thank Alllllllllllllllllllllllllllllllllll......I think this is ok for all of us if i say like Thank you all...
But one thing whenever i post a query i get the answers soon from Mr.Gila Monster and Mr.Grant ,So i always thanking them by the Name...
Thats y i mentioned My Favorite Name ..:-)
Thanking people is not an issue at all. And, for my part, Gail is a constant source of knowledge and inspiration. But the real issue is that Gail is of the female persuasion, so calling her "Mr." sort of doesn't work. I think that's what people were pointing out.
"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
July 10, 2014 at 10:56 pm
Dont blame OP... I too thought her to be him (as is evident by her display pic) in my beginner days. I got corrected when when I visted her blog and read her intro... 😀
Cheers
July 11, 2014 at 2:24 am
AppSup_dba (7/10/2014)
as is evident by her display pic
Which is Qui-gon Jinn from the Star Wars movie The Phantom Menace.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2014 at 4:25 am
Am Very Sorry Mam @ Gila Monster........
Regards
Chowdary...
July 11, 2014 at 4:27 am
I Don't want blame anyone in our portal because i feel like this is my family Portal...
Regards
Chowdary...
July 11, 2014 at 4:34 am
Am very sorry Mam @ GilaMonster...
And i never try to blame anyone becoz i feel this portal is my family Portal....
But i thought to say by the name so i have mentioned the name....
Regards
Jagadeesh....
Regards
Chowdary...
July 11, 2014 at 4:35 am
Am very sorry Mam @ GilaMonster...
And i never try to blame anyone becoz i feel this portal is my family Portal....
But i thought to say by the name so i have mentioned the name....
Regards
Jagadeesh....
Regards
Chowdary...
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply