|
Home > Archive > MS SQL Server > June 2005 > How to get list of backup log files from msdb of standby server?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to get list of backup log files from msdb of standby server?
|
|
|
| How do we retrieve log file names of primary backup from msdb of
standby database?
In case of primary server unavailable, I need to get the logfile names
from standby server for disater recovery test.
Thanks in advance
Tram
| |
|
| Msdb..backupfile gives you a list of data/log files that are backed up.
For logshipping, take a look at msdb.. log_shipping_plan_da
tabases.
--
-oj
"tram" <tram_e@hotmail.com> wrote in message
news:1120079449.879078.169120@o13g2000cwo.googlegroups.com...
> How do we retrieve log file names of primary backup from msdb of
> standby database?
> In case of primary server unavailable, I need to get the logfile names
> from standby server for disater recovery test.
>
> Thanks in advance
>
> Tram
>
|
|
|
|
|