Geeks With Blogs

News
David Christiansen | davidchristiansen.com 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_enpo... 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 On Thursday, July 28, 2005 7:38 AM

Copyright © David Christiansen | Powered by: GeeksWithBlogs.net | Join free