July 17, 2009 at 6:33 am
...
July 17, 2009 at 6:55 am
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.
July 17, 2009 at 8:26 am
.....
July 17, 2009 at 10:38 am
(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.
July 17, 2009 at 10:46 am
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
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- 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
August 3, 2009 at 3:04 am
thanks...........
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply