January 10, 2018 at 11:45 am
For some reason I am unable to generate the script to restore the database so I wrote this script to restore the database, plus all the log backups since morning. Does it look ok? Someone ended up deleting bunch of records from the table and I am trying to perform point in time recovery. Luckily the table was dropped around 11:05 and the log backup ran around 11.
restore database [CycleEnd] from disk = N'k:\SQL_BKP\[CycleEnd]\201802\[CycleEnd]_20180109_232153.bak' with norecovery, replace, stats = 5
restore log [CycleEnd] from disk = N'k:\SQL_BKP\[CycleEnd]\201802\[CycleEnd]_20180110_030002.trn' with norecovery, stats = 5
restore log [CycleEnd] from disk = N'k:\SQL_BKP\[CycleEnd]\201802\[CycleEnd]_20180110_040004.trn' with norecovery, stats = 5
restore log [CycleEnd] from disk = N'k:\SQL_BKP\[CycleEnd]\201802\[CycleEnd]_20180110_050006.trn' with norecovery, stats = 5
restore log [CycleEnd] from disk = N'k:\SQL_BKP\[CycleEnd]\201802\[CycleEnd]_20180110_060011.trn' with norecovery, stats = 5
restore log [CycleEnd] from disk = N'k:\SQL_BKP\[CycleEnd]\201802\[CycleEnd]_20180110_070004.trn' with norecovery, stats = 5
restore log [CycleEnd] from disk = N'k:\SQL_BKP\[CycleEnd]\201802\[CycleEnd]_20180110_080008.trn' with norecovery, stats = 5
restore log [CycleEnd] from disk = N'k:\SQL_BKP\[CycleEnd]\201802\[CycleEnd]_20180110_090005.trn' with norecovery, stats = 5
restore log [CycleEnd] from disk = N'k:\SQL_BKP\[CycleEnd]\201802\[CycleEnd]_20180110_100018.trn' with norecovery, stats = 5
restore log [CycleEnd] from disk = N'k:\SQL_BKP\[CycleEnd]\201802\[CycleEnd]_20180110_110011.trn' with recovery, stats = 5
January 10, 2018 at 12:23 pm
Nevermind. The database is restored and I am able to see the table. Thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply