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

Mirrored Database Expand / Collapse
Author
Message
Posted Friday, July 17, 2009 6:33 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Yesterday @ 3:01 AM
Points: 430, Visits: 1,067
...
Post #754772
Posted Friday, July 17, 2009 6:55 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 3:53 PM
Points: 60, Visits: 1,111
Database mirroring is not available in SQL Server 2000. It is available in SQL Server 2005 and beyond. As for monitoring, I would recommend looking at the DMVs related to mirroring, such as sys.database_mirroring, sys.database_mirroring_endpoints, sys.database_mirroring_witnesses, sys.dm_db_mirroring_connections.

If you use SSMS to create a mirrored database pair, a SQL Agent job named Database Mirroring Monitor Job will be created, which executes the exec sys.sp_dbmmonitorupdate procedure.
Post #754780
Posted Friday, July 17, 2009 8:26 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Yesterday @ 3:01 AM
Points: 430, Visits: 1,067
.....
Post #754863
Posted Friday, July 17, 2009 10:38 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Yesterday @ 3:01 AM
Points: 430, Visits: 1,067
(If principle database gows down then mirror database takes the charge.
Then that time i want to get the alert message with both databases status.)

I need the sp for this(using above logic).I am using dbmail.
Post #754987
Posted Friday, July 17, 2009 10:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 10:42 AM
Points: 6,731, Visits: 8,480
Please post in the correct forum !

Search SSC for mirroring and it will come op with the script you need !

IMO best is to use SQLServer events for this !

e.g.
http://msdn.microsoft.com/en-us/library/ms191502%28SQL.90%29.aspx

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31919/

http://msdn.microsoft.com/en-us/library/ms408393%28SQL.90%29.aspx


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #754995
Posted Monday, August 3, 2009 3:04 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Yesterday @ 3:01 AM
Points: 430, Visits: 1,067
thanks...........
Post #763945
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse