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
Filed under: Uncategorized No Comments