Is there a T-SQL script to determine a database is currently mirroring or not? Is there a way to determine its partner?
Thank you very much.
+2
A:
The system view / catalog sys.database_mirroring gives a comphrehensive breakdown of the fields available. http://msdn.microsoft.com/en-us/library/ms178655.aspx
Andrew
2010-02-03 09:40:23
great! I'm reading it. Thank you.EDIT: solve my problem completely. Thank you, again :D
Vimvq1987
2010-02-03 09:44:03