Missing LSN error in restore process

Question

Missing LSN error in restore process

Cole Butterworth

SSC Enthusiast

Points: 174
More actions
August 23, 2005 at 6:47 pm

#110083

Hi
I have a corrupt SQL Server database. I can restore from a full backup and multiple log file backups.
I am missing one log file and therefore cannot restore past that point. Gives me an incorrect LSN error.

Is there any way of telling sql server to ignore the missing log file.

Thanks

Cole Butterworth

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

philcart SSC-Forever Points: 47794 More actions · Answer 1

Ahh ... no ... what would be the point? How could you guarantee the integrity of the data given that you'll be missing a whole pile of transactions. Its most likely that the transactions in subsequent log files only took place on data that was changed in the missing transactions.

eg:

tran 1 increments a balance by 100 to 1100

tran 2 decrements the same balance by 200 to 900

tran 3 increments the same balance by 100 to 1000

if tran 2 goes missing and you still apply tran 3 then you'll end up with an incorrect balance of 1200

--------------------
Colt 45 - the original point and click interface

Cole Butterworth SSC Enthusiast Points: 174 More actions · Answer 2

Thanks Phill

I realise that I am playing with fire here. My thoughts are that since this is simply a document storage database, and the missing log is from a weekend backup when there is usually no staff working, then I may be lucky.

philcart SSC-Forever Points: 47794 More actions · Answer 3

There is no such thing as being lucky in the DBA world

--------------------
Colt 45 - the original point and click interface

Karl Klingler SSCertifiable Points: 5869 More actions · Answer 4

One method to get the rest of the logfiles into the server would be to use a third-party tool (Apex SQL Log claims to be able to do that) to convert the log backups to redo-scripts and execute them.

Of course the logical integrity of the db from that point on is questionable...

regards karl

Best regards
karl

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 5

If it's truly a 'simple' document storage database why not just execute the document reindexing ... If I understand correctly that a DMS does not store the actual documents, just pointers (so to speak) to the actual document files. Am I far of base on this one ?

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Cole Butterworth SSC Enthusiast Points: 174 More actions · Answer 6

Thanks for all the replies. I will have a look at that 3rd party tool by Apex.

The reindexing may work if I had not lost the entire drive. All that is remaining is this old sql backup.