Log shipping

Hi:

Is there a way to find through T-SQL Code if log shipping is setup on a SQL Server and how many secondary servers does it have?.

Thanks

Ankith

[171 byte] By [Ankith] at [2007-12-22]

«« Extending Applications with AddIns using MAF/VSTA - Blog Posts and Review
»» Tracking Service

# 1

take a look at log_shipping_primaries and log_shipping_secondaries in msdb database. This assumes you have enterprise edition and configure logshipping via the UI. If you create your own logshipping, these tables will not have any info.

oj at 2007-8-30 >

SQL Server

count problem
results to string array for reference within CLR Proc
How to Pass pass the Parameter in SQL command in SSIS Package
Problem to create assembly which depends on other dll's from SQL Server
transaction context in use by another session error in c# sp from trigger
Debugging SQL CLR as non-admin
Problems with debugging remotely SQLCLR stored procedures?
How can I connect to Exchange Server2003's Web Store?
Database Restore, Error 3154 and
Execute As error

SQL Server Database Engine

PRINTing problem
Image in 2000 to Varbinary(max) in 2005 won't release space
COLLATE Problem
my update index script broke...
Problem Insert into from Linked Server SP.
Slow Response Within Enterprise Manager
SQL collation, German characters do not show up correctly
Sql Server Replication
Triggers fire when no records are affected?
Transaction log keeps growing

SQL Server Hot Topic

count problem
Database Restore, Error 3154 and
Execute As error
Database attach error 3624
Do any ISP's really host SQL 2005 Express
SQL Server Setup failed to retrieve the SSL Certificate Name
The connection manager 'OLEDB' is not properly installed on this computer
SQL Server 2005 hotFix 2153 won't install

SQL Server New Topic

How can I connect to Exchange Server2003's Web Store?
Moving SQL servers from an NT4 domain to a Windows 2003 domain
Accessing Arrays data
Access Reporting Services parameters from external application
How to integrate Oracle with SQL Server 2005 by link server?
AlternatingItemStyle on RS 2000
Debuggin in 05 when running a local instance
package configuration into SQL Server

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Log shipping document under SQL Server Database Engine classified...

Log shipping

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified