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 |
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
 Posted - 2010-11-15 : 08:08:00
|
| I encountered an issue while performing a DB failover.First, I configured the principal and mirror databases in High Safety without Automatic Failover mode. Then I wanted to verify if failover actually works when performed from mirrored database. I had shut down the SQL Server service on principal database and then tried to perform failover on the mirrored database using the following command:alter database <db_name> set partner failover;Following is the output of above command:The command failed because the database mirror is busy. Reissue the I command later.Ideally, a failover should have occurred but I am not sure what I missed out.I used the following commands on mirrored database as a workaround which is obviously not a good approach.alter database <db_name> set partner off;restore database <db_name> with recovery;The above workaround, though, brought the mirrored database up but it removed mirroring and thus, it is required to be configured again, which in production environment is not a good thing. |
|
|
|
|
|
Failover does not work when done from mirrored DB