Sysadminsblog.com Anything for sysadmins!

6Jan/110

RESTORE cannot operate on database because it is configured for database mirroring

If you’re trying to remove database mirroring from a DB, the mirror server will keep the DB in recovery mode. To take it out of recovery mode you’ll have to run the following query:

ALTER DATABASE <Database> SET PARTNER OFF
Be Sociable, Share!

Posted by Mischa Oudhof

Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

No trackbacks yet.