How to: Remove Database Mirroring (Transact-SQL)

To remove database mirroring

1. Connect to either partner.
2. Issue the following Transact-SQL statement:

ALTER DATABASE <database_name> SET PARTNER OFF

where <database_name> is the mirrored database whose session you want to remove.

This statement removes the database mirroring session and removes mirroring from the database. You can specify OFF on either partner. For more information about the impact of removing database mirroring, see Removing Database Mirroring.

1. Optionally, you can recover the former mirror database. On the server instance that was the mirror server, enter:

RESTORE DATABASE <database_name> WITH RECOVERY;