Microsoft® SQL Server 2012 Unleashed

Removing Mirroring

Very likely, you will have to remove all traces of database mirroring from each server instance of a database mirroring configuration at some point. Doing so is actually pretty easy. Basically, you have to disable mirroring of the principal, drop the mirror server’s database, and remove all endpoints from each server instance. You can simply start from the Database Properties page and the Mirroring option and do the whole thing. Alternatively, you can do this through SQL scripts. Let’s first use the Mirroring options. Looking at the options on Figure 41.23, you simply choose to remove mirroring (from the principal server instance). This is just a bit too easy to do—almost dangerous!

FIGURE 41.23 Removing database mirroring. ...