SQL Backup Log shipping
pcorujo
Posts: 14
HI All,
I am setting up log shipping from SQL 2005 to SQL 2008 in order to migrate from a stand alone server on 2005 to a cluster on 2008 R2.
When I setup log shipping through the SSMS GUI records are logged in the table log_shipping_monitor_secondary. I typically use this table to be sure that the logs are being applied and copied properly.
Does Red Gate have a similar set of tables which I can use to monitor things?
Thank you in advance,
Paul
I am setting up log shipping from SQL 2005 to SQL 2008 in order to migrate from a stand alone server on 2005 to a cluster on 2008 R2.
When I setup log shipping through the SSMS GUI records are logged in the table log_shipping_monitor_secondary. I typically use this table to be sure that the logs are being applied and copied properly.
Does Red Gate have a similar set of tables which I can use to monitor things?
Thank you in advance,
Paul
