locked
Unable to drop database which was in Mirroring RRS feed

  • Question

  • Hi, I have database with mirroring, before 1 month I remove the mirroring on primary server. So now I want to drop the mirrored DB on mirrored server. But I'm unable to do this. It shows 

    the command failed because the database mirror is busy. reissue the command later

    So I tried the below commands,

    alter database dbname set partner off;

    Drop database dbname; 

    alter database dbname set partner force_service_allow_data_loss;

    restore database dbname with recovery.

    I tried to drop manually, but no use. Please help me to fix this. 

    Thursday, September 15, 2016 10:03 AM

All replies

  • ALTER DATABASE [DB] SET PARTNER OFF
    go

    RESTORE DATABASE [DB] WITH RECOVERY
    go

    DROP DATABASE [DB]
    go

    Please click Mark As Answer if my post helped.

    Thursday, September 15, 2016 12:21 PM
  • I tried this but SQL throws 

    the command failed because the database mirror is busy. reissue the command later

    Thursday, September 15, 2016 4:39 PM
  • Which of the commands threw that error?

    Edit: And what SQL version are you using?

    Thursday, September 15, 2016 6:54 PM
  • see this

    https://sergessqlnotes.wordpress.com/2011/07/04/the-command-failed-because-the-database-mirror-is-busy/


    Regards, S_NO "_"

    • Proposed as answer by Teige Gao Thursday, September 29, 2016 9:35 AM
    Monday, September 19, 2016 3:18 AM