SQL Server Performance Forum – Threads Archive

Disaster recovery

Hello All, I would like to know about one scenario, that is, If we have a full back of a database(with full recovery mode) at 12:00 AM and log backups(for every one hour) till 10:00 AM and server is crashed at 10:30 AM then by restoring the full and log backups we can recover the data till 10:00 AM, is there any way to recover the data of 10:00 to 10:30 AM? I heard that it is possible using the LSN number… can some one please help me the way to recover that half an hour data. Your help will be greatly appreciated, Thanks much,
Mahi

IS it for SQL 2005 or 2000? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

I don’t think it is possible to recovery the 10-10.30 am data without tlog backup. If you are able to backup the tail of a tlog then you are good other wise you can get upto 10 am only…
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

When you start up the SQL SErver (primary) then you will be able to recover the transactions that are committed provided there are no issues with the files, uncommitted transactions will be lost. For this reason better to keepup 15 minutes log shipping in place. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Hi satya, it is in SQL 2000 and the primary server got crashed completed.. Mahi

When u speak in terms of server, u need to think about moving towards Logshipping (in 2000) as Satya suggested or Database Mirroring (an option 2005). Satya

]]>