News

Subscribe!

Disclaimer

This blog and the postings therein are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the general copyright terms.

My Stats

  • Posts - 101
  • Comments - 41
  • Trackbacks - 38

Twitter












Tag Cloud


Recent Comments


Recent Posts


Article Categories


Archives


Post Categories


Image Galleries


.NET Links


.Text Links


Blogs i read...


eGovernment


ePolicing


Microsofty


Misc.


Mountain Biking


MS Patterns & Practices


July 2005 Entries

SQL 2005 Database Mirroring - Providing automated failover for legacy systems


Well, it turns out that you can (as a DBAdmin) interogate the sys.database_mirroring, sys.database_mirroring_enpoints views to find out all the information you require about your database mirroring 'collective' including which servers are involved, their roles (Principle, Mirror, Witness), their state and the ports that they have been configured on.

Click here to read more...

posted @ Thursday, July 28, 2005 7:38 AM | Feedback (2) | Filed Under [ Microsoft Platform Development ]