Hi
I am testing high performance mirror on my local PC
mirroring set on db Northwind between default and named instance
on default (principal) server have few jobs
1. insert into table A,run every 1 minute
2. backup log of Northwind ,run every 10 minute
3. stop named instance ,run every 15 minutes
4. start named instance ,run every 20 minutes
After each stop/ start mirrored db very quickly synchronized .
I want to test break of mirror db when synchronization no longer possible
any suggestions ?
We want to place 70 GB db in mirror 300 km away and I want test everything
All possible break scenario
I didn't understand your question completely "I want to test break of mirror db when synchronization no longer possible". However, the following document describes quite a few test scenarios for database mirroring, and may be helpful.
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
No comments:
Post a Comment