June 18, 2009 at 2:05 pm
Hi
I have two questions.
1 . Which system views can i refer for finding out the LSN of each log file? In the case of a Standby i have log_shipping_monitor_history_detail view.
2. While Recovering a database by applying a log file , is there a way i can ask the recovery command to begin at a particular LSN and end at a particular LSN?
TIA
You should treat others the way you want to be treated - Mahatma Gandhi
June 18, 2009 at 2:09 pm
gk (6/18/2009)
1 . Which system views can i refer for finding out the LSN of each log file? In the case of a Standby i have log_shipping_monitor_history_detail view.
You can query backupset table which is stored in msdb database for first and last lsn of a particular backup.
2. While Recovering a database by applying a log file , is there a way i can ask the recovery command to begin at a particular LSN and end at a particular LSN?
I dont think this is possible. You an use STOPAT clause to stop recovering after a specific time but cannot specify which LSN to end at. Also, u cannot change start lsn as the log chain will be broken..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply