To remove mirroring we can just use the mirror wizard and choose to break the mirror. After that the mirror will be in restoring state. This is how to fix this:
RESTORE DATABASE mydbname WITH RECOVERY;
When the databse is in workign mode againaa we might need to remove the mirror setting by runnign this code:
ALTER DATABASE mydbname SET PARTNER OFF
No comments:
Post a Comment