Monday, March 26, 2012

Mirror database-How do I remove it from being the mirror

I was trying to test mirroring and now would like to delete the mirror database but it says I need to remove database mirroring first. I deleted the endpoint and cannot figure out how to remove the mirroring. Can someone please help.

Hi Pamela,

Deleting the endpoint does not remove mirroring, only disconnects it. You can remove mirroring by executing the T-SQL statement below. Note, however that since you removed the endpoint, you may need to execute the statement on both partners in order to remove the two copies of DB:

ALTER DATABASE <your_db_name> SET PARTNER OFF.

Thanks,

Kaloian.

No comments:

Post a Comment