Friday, March 23, 2012

I want to test break of mirror db when syncronization no longer possible

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