September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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 20.22, you simply choose to remove mirroring (from the principal server instance). This is just a bit too easy to do—almost dangerous!
Figure 20.22 Removing database mirroring. ...