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
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment