SQL Server Performance

Not able to delete the mirrored database

Discussion in 'SQL Server 2005 General DBA Questions' started by contactjimmyus, Oct 27, 2010.

  1. contactjimmyus Member

    ONE Database was mirrored to another server and it was working for a long time .Due to some issue the data base on mirror seems correpted.
    Inorder reestablish the mirroring I tried to removed the mirroring on the db and tried to delete the db from the mirrored server .I
    used the commandAlter database [database Name] set partner offRESTORE database [database Name] with recovery
    these commands are not responding and the error wasThe command failed because the database mirror is busy. Reissue the command later.
    What else can be done to delete the db and recreate the mirroring again
    Thanks a lot for any advice and suggestions
    contactjimmyus, Oct 27, 2010
    #2

  2. Luis Martin Moderator

    Check:
    http://connect.microsoft.com/SQLServer/feedback/details/124899/bug-database-mirroring-will-not-remove-and-leaves-a-database-inoperable
    http://social.msdn.microsoft.com/forums/en-US/sqldatabasemirroring/thread/b4bfe12e-7da8-430d-b258-2ca5edb77bef/
    HTH
    Luis Martin, Oct 27, 2010
    #3

Share This Page