Yak Posting Veteran
Posted - 11/15/2010 : 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.