Friday, March 9, 2012

Expected LSN

Is it possible to query the next expected LSN from a DB in recovery/standby?
I know that if you try to restore a log backup out of sequence, SQL Server
throws error #4326 which will tell you the LSN you just tried to restore and
the expected one, but is it possible to get this info without having to
attempt a log restore?
ThanksHi Peter
RESTORE HEADERONLY will give you the LSN range.
John
"Peter Reid" wrote:

> Is it possible to query the next expected LSN from a DB in recovery/standb
y?
> I know that if you try to restore a log backup out of sequence, SQL Server
> throws error #4326 which will tell you the LSN you just tried to restore a
nd
> the expected one, but is it possible to get this info without having to
> attempt a log restore?
> Thanks
>
>

No comments:

Post a Comment