sql server replication:
Hi All,

Just a stupid question for you all :)

We have log shipping set up (SQL 2005) and running perfectly fine. We have
one primary server and one secondary server with one database.

Occasionallyi would like to manually enter a query or procedure on both the
primary and secondary servers that will display information such as:
* Last transaction log restored in secondary
* tables , consistency checks, etc

I want to do this just for peace of mind.

Does anybody know if this is possible and if so what i can do? We have
monitoring already set up but i just want to be able to do this extra
function as well.

Thanks


--

Jason,
the log shipping monitor will give you some of this info, or you could use
"sp_help_log_shipping_monitor_secondary". To be able to query the tables,
restore the secondary server in standby mode. When running the queries, the
only thing to be sure of is that you don't do it when the logs are being
restored.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Hi Paul,

How do you view this information through the log shipping monitor?

Thanks


--
Jason Murray


[quoted text, click to view]