开发者

Recovering transaction log from corrupt SQL Server database

开发者 https://www.devze.com 2022-12-24 10:38 出处:网络
We have a database that is backed up weekly in simple mode.Yesterday, we had a crc error corrupt the mdf file and we were unable to save it.I restored the backup from last week, but now we have a gap

We have a database that is backed up weekly in simple mode. Yesterday, we had a crc error corrupt the mdf file and we were unable to save it. I restored the backup from last week, but now we have a gap from the time of the backup to the time of the restore. Since I have the ldf file from that database, is there any way to "replay" that transaction l开发者_如何学JAVAog to fill in the gap?

I have tried reattaching the ldf file to the recovered mdf file, but SQL Server will not allow me to do that. (It just creates a new ldf file with a different name when I reattach the database.)

Any ideas would help. This is a lot of data to lose and although it is not critical data, I'd like to get it back (as well as learn as well as learn how to do it.)


If you follow the instructions from MSDN -How to: Restore to a Point in Time (SQL Server Management Studio) you should be good. I will not reproduce them here as they are quite long. There is also MSDN - How to: Restore a Transaction Log Backup

0

精彩评论

暂无评论...
验证码 换一张
取 消