How to get that LSN No. which is a recovery point.

Question

How to get that LSN No. which is a recovery point.

forsqlserver

SSCoach

Points: 18902
More actions
May 6, 2011 at 4:10 am

#250395

How to get that LSN No. which is a recovery point.
http://msdn.microsoft.com/en-us/library/ms191459.aspx
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

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

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 1

you can check this restore statement with headeronly clause it will provide backup file information and lsn information also

RESTORE headeronly FROM DISK = N'C:\vbslog'

GO

USE MSDB

GO

SELECT * FROM BACKUPFILE

GO

for information you can use for more detail as

Restore Labelonly

Restore FileListonly

My Blog
www.aureus-salah.com

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

What do you mean by a recovery point?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

forsqlserver SSCoach Points: 18902 More actions · Answer 3

The point in time restore or Restore database is depepnd on recovery point.

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

You're not being clear. A point-in-time restore can be done to any point (time or LSN) that's covered by your log backups

What exactly do you want? Explain in detail

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

forsqlserver SSCoach Points: 18902 More actions · Answer 5

When I was reading this link :http://msdn.microsoft.com/en-us/library/ms191459.aspx

Then this below command I have seen:

RESTORE LOG AdventureWorks2008R2 FROM DISK = 'c:\adventureworks2008R2_log.bak'

WITH STOPATMARK = 'lsn:15000000040000037'

GO

Therefore I have asked How to get Recovery Point LSN NO.

Please correct me ...I know I dont know much...

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

That can be any LSN in the interval covered by that log backup. You can use RESTORE HEADERONLY to see the LSN range that a log backup covers.

That's a very unusual way of stopping a restore at a point. It's far more common to stop at a time or a transaction mark.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

forsqlserver SSCoach Points: 18902 More actions · Answer 7

The out put I am Getting is

First LSN :19000000043500037

Last LSN :19000000045300001

Checkpoint LSN :19000000043500037

DatabackupLSN :0

Thanks..

May I know which LSN is recovery point?

First LSN and Checkpint LSN are same?

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

There isn't a single recovery point.

What that LSN is, is the point that you would want the log restore to stop at, based on what you would know about the operations that had happened and the reason for the restore.

As I said, Using StopAtMark is a very unusual restore option, you wouldn't use it unless you somehow knew what LSN you wanted to stop at. Far more common is STOPAT with a time

The checkpoint LSN is of no value here, it's just saying when the last checkpoint ran. It's the first and last that show what LSN interval is in this log backup

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass