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 |
|
lluisdelta
Starting Member
9 Posts |
 Posted - 2008-10-31 : 16:51:38
|
| Hi,I have 2 SQL 2005 servers working in a mirror config, high protection mode (no witness). As a disaster recovery plan I wanted to make sure the failover will be seamless. I assumed that (principal) was down. Working on (mirror), tried to promote all databases in the mirror with:ALTER DATABASE <db_name> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS;but received an error about the database not being in a state that it can be promoted.I ended up going to the (principal) and manually failing over databases individually (through SSMS). The test went through, all the services were made available in the (mirror) server. However this doesnt seem like the real test, because in the real world the principal is down and inaccessible. Any suggestion on a better way to challenge the mirror?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lluisdelta
Starting Member
9 Posts |
Posted - 2008-10-31 : 19:55:13
|
| Makes sense. Great! Thanks for your reply! |
 |
|
|
|
|
|
Mirror failover