Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

mirroring Expand / Collapse
Author
Message
Posted Monday, July 20, 2009 6:31 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:23 AM
Points: 412, Visits: 1,012
what is the systemtable for storing records of datbase mirror states?
Post #755703
Posted Monday, July 20, 2009 7:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
There is a view that you can query

 select * from sys.database_mirroring   

you can read more about the mirroring catalog views on

http://msdn.microsoft.com/en-us/library/ms178655(SQL.90).aspx
Post #755771
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse