April 3, 2010 at 12:19 am
Hi
I have a db, one of my colleague opened the .mdf file in scite editor & deleted few rows from that .mdf file. Now when I restarted the server I found state_desc="Recovery_Pending", it was full recovery mode.
When I check SQL error logs, I found an error mentioned below:-
SQL Server has detected a logical consistency based I/O error: restore pending. It occurred during a read of page (1:0) in database ID 13 at offset 0000000000000 in g:\data\ICT.mdf
It is a large database, how can I go online? I have full backup & transaction backup but I don't have transaction backup of 20 minutes. Will I loose that 20 minutes ? Please suggest I am in deep trouble as it is very critical data I can not afford to loose that.
April 3, 2010 at 6:28 am
beejug1983 (4/3/2010)
I have a db, one of my colleague opened the .mdf file in scite editor & deleted few rows from that .mdf file.
Well that was a bit silly, wasn't it? What on earth possessed you to do that?
It is a large database, how can I go online? I have full backup & transaction backup but I don't have transaction backup of 20 minutes. Will I lose that 20 minutes ? Please suggest I am in deep trouble as it is very critical data I can not afford to lose that.
The best you can do is to restore from backup and and hope for the best. You will lose at least 20 minutes of data, yes. If the restore completes successfully, that is.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply