Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shahab03
Starting Member
28 Posts |
 Posted - 2008-04-22 : 09:53:50
|
| I have a log shipping configuration where Server A is primary, B is secondary and C is the monitoring Server. When I run a query on both A and B I get similar results. Which means log shipping is working fine.However when I run 'Transaction Log Shipping Status' Report on the monitor server I am unable to tell which files were recently copy and which files were last applied. or even when the last backup occurred or a copy was made. The columns are empty. I would like to find out what would cause this to heppen?Also is there a way to find out the lsn of the databases on both primary and secondary servers.thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-22 : 15:48:36
|
| Try this:sp_help_log_shipping_monitor |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-22 : 21:57:43
|
| Or check standard backup/restore report in ssms. |
|
|
|
shahab03
Starting Member
28 Posts |
Posted - 2008-04-23 : 10:27:43
|
| ran the procedure. and following columns are still null.time_since_last_copylast_copied_filetime_since_last_restore last_restored_filelast_restored_latency restore_threshold is_restore_alert_enabledwhy would they be null? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-23 : 11:29:59
|
| Check the job history in primary and secondary server? Are they running well? |
|
|
|
|
|
|
log shipping status