| Author |
Expected LSN of a standby DB
|
|
| Peter Reid 2006-01-19, 3:23 am |
| thanks john, but RESTORE HEADERONLY will give me the LSN range in the backup
file.
I'm after the LSN a standby database is expecting next...
"John Bell" < jbellnewsposts@hotma
il.com> wrote in message
news:AEFF783B-174E-493D-8CB1- 83625E9D792F@microso
ft.com...[color=darkred]
> Hi Peter
>
> RESTORE HEADERONLY will give you the LSN range.
>
> John
>
> "Peter Reid" wrote:
>
| |
| John Bell 2006-01-19, 3:23 am |
| Hi
You may want DBCC DBINFO, this is undocumented
See
http://www.sql-server-performance.c...mented_dbcc.asp
John
"Peter Reid" wrote:
> thanks john, but RESTORE HEADERONLY will give me the LSN range in the backup
> file.
> I'm after the LSN a standby database is expecting next...
>
>
>
> "John Bell" < jbellnewsposts@hotma
il.com> wrote in message
> news:AEFF783B-174E-493D-8CB1- 83625E9D792F@microso
ft.com...
>
>
>
| |
| Amish Shah 2006-01-19, 7:23 am |
|
Run
DBCC TraceOn(3604)-- to view the result in query analyzer.
DBCC DBInfo(<dbname> )
Regards
Amish
*** Sent via Developersdex http://www.droptable.com ***
|
|
|
|