Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2007-03-23 : 08:26:48
|
| what are the different testing we can do for the database mirroring with witness and without witness ??thanks |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-23 : 12:12:30
|
| 1. Create a database, mirror it without a witness, detach it to simulate a failure, perform a manual failover to the mirror.2. Create a database, mirror it with a witness and set it to use automatic failover, detach it to simulate a failure, see automatic failover.Take a look at "Testing Database Mirroring" in this articlehttp://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx |
 |
|
|
|
|
|
database mirroring testing