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.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 how to get backup job id from secondary id

Author  Topic 

Sasikala
Starting Member

8 Posts

Posted - 2010-05-10 : 08:03:31
Hi,

In primary server database, the table called 'log_shipping_primary_databases' has the columns primary_id and backup_job_id.

But in the secondary server database, none of the table has this mapping, secondary_id and its backup and restore job id?

Is there a way to get this mapping?

Sasikala
Starting Member

8 Posts

Posted - 2010-05-10 : 08:13:16
Hi all,

Just a note : This query is on log shipping.

Thanks.
Go to Top of Page
   

- Advertisement -