database mirroring testing | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

database mirroring testing

what are the different testing we can do for the database mirroring with witness and without witness ?? thanks
1. Try doing a failover from principal to mirrored databases (you can try both manual and automatic) 2. You can also try doing dml, ddl changes on the principal server and see if the changes are going thru to other side by using d/b snapshots Satya
Read the following article…specially topic "Testing Methodology and Workloads" Database Mirroring Best Practices and Performance Considerations MohammedU.