How to take over the mirror when principal is shut down unexpectedly RRS feed

  • Question

  • Hi,

    I configured SQL Server 2005 mirroring, I am using Standart Edition and SP1. I dont use a witness server thus it will be manual failover.
    I shutdown the principal, to check if the mirrored db is working okay, issued:

    alter database Wss_content1 SET PARTNER FAILOVER   command
    and got the error:

    The command failed because the database mirror is busy. Reissue the command later.

    how can i open the mirror?  

    Tuesday, February 2, 2010 8:08 AM