SQL 2005 Database Mirroring – Providing automated failover for legacy systems

July 28, 2005 Off By David

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…