question

pits avatar image
pits asked

lsn missing

Hello Experts. i restored full backup and while restoring tlog back noticed error message LSN missing? what is the reason of message? why it is occured? how we can avoid such error in future?
lsn missing
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Cyborg avatar image
Cyborg answered
The message says either you missed to apply a log backup between your restores or you have a [broken lsn][1]. A broken LSN occurs when you switches your recovery model, or when you take backups for special purpose other than your backup plans like for development or testing with out [COPY_ONLY][2] option, this breaks the LSNs and disturbs the restore order. [1]: http://msdn.microsoft.com/en-us/library/ms190729(v=sql.105).aspx [2]: http://msdn.microsoft.com/en-us/library/ms191495.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.