SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 sql server 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gsuresh
Starting Member

India
22 Posts

Posted - 11/22/2012 :  08:41:04  Show Profile  Reply with Quote
.............>backup scenario<..............
full ---->12:00p.m
differential ----->6:00p.m
differential ----->8:00p.m
server crash ------>9:00p.m what will u do to bring server online?


suresh

srimami
Posting Yak Master

160 Posts

Posted - 11/28/2012 :  07:26:40  Show Profile  Reply with Quote
If you set up transactional log, you can restore till crash else you will be losing the data from 8PM till 9PM.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/11/2013 :  12:57:00  Show Profile  Reply with Quote
quote:
Originally posted by gsuresh

.............>backup scenario<..............
full ---->12:00p.m
differential ----->6:00p.m
differential ----->8:00p.m
server crash ------>9:00p.m what will u do to bring server online?


suresh



In the restoring process, first take the tail log backup.
If the log file and the data file are there in two separate disks in the hard drive or in any sought of external media. Then even the crach will be recorded in the log.

so now to restore...
1.take the tail log backup(take log backup)
2.Then first restore the full backup
3.then restore the differential backup taken at 8pm.(because,each diff backup will be storing the details from last full backup to the present time)
3.now restore the tail log backup which was taken in the beginning of restore process.

now not even a single data modification will be lost.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000