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 ?? thanks1. 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
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx MohammedU.
Moderator
SQL-Server-Performance.com
]]>