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?
Thanks
Hi 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/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?
> Thanks
>
>
Showing posts with label standbyi. Show all posts
Showing posts with label standbyi. Show all posts
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
>
>
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:
Posts (Atom)