Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2011-03-02 : 06:15:15
|
Hi,Please reply for below Scenario.This My Backup Policy of Sample Database.Every Day 12 AM Full Backup of Database.Every 6 Hours Differential Backup.Every 15 Min Transactional Log Backup.Our Database was crashed in 3.25 AM Including Transactional Log file also crashed.How to restore the Sample Database with Specific Point in time (3.25) AM?----Ragu ThangavelJunier Sql Server DBA |
|
Sachin.Nand
2937 Posts |
Posted - 2011-03-02 : 06:55:47
|
It means you would be having a T log backup till 3:15 AM.Take a tail log backup,restore your last Full Backup,then last differential backup if available and all the available tlog backup i.e till 3:15 am and then restore the tail log backup.PBUH |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-03-02 : 06:59:26
|
Oops sorry I overlooked that you mentioned that Tlog file also crashed.So it would mean that you wont be able to take Tail log backup.So I don't think it would be possible to have a point in time restore.PBUH |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-03-02 : 11:00:47
|
Hi Schin,Ragu is taking full backup at 12AM and differential backup schedule after 6 hours. So in this case I think he will restore last full backup and then available transactin log backups. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-03-03 : 00:18:15
|
Yes I agree.But he wont be able to do a point in time restore till 3:25.PBUH |
|
|
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2011-03-03 : 00:52:40
|
so it's not possible to restore a database to specific point in time. My assumption is correct.--Ragu ThangavelJunier Sql Server DBA |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-03-03 : 01:17:34
|
Yes but restore should be your last resort.You can try to repair the database using DBCC CheckDB REPAIR_REBUILD or if possible use some 3rd party tool to repair the Tlog file.PBUH |
|
|
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2011-03-03 : 01:46:14
|
Thanks all participants for your KT to me,It's very useful for my carrier.--Ragu ThangavelJunier Sql Server DBA |
|
|
|
|
|