Unable to remove mirroring getting an error "database mirror is busy" RRS feed

  • Question

  • I have fired the command on principal server 'alter database database_name set partner off' it removes there but when i am going to fire the command on mirrored server then getting an error "command failed because database mirror is busy" .

    and database is showing in GUI as mirroring disconnected/restoring.

    There is no database snapshot on server. i tried the following steps but nothing works.

    1.  restore database DB_name with recovery

    2. sp_reset database status

    3. restore database with replace.

    4. set partner force allow service data loss

    I don't understand where is the db showing is in use and why its not removed completly. please help how to solve this.

    • Edited by Mayur-DEW Sunday, April 17, 2016 12:53 PM
    Sunday, April 17, 2016 12:48 PM


All replies