Setting Up and Configuring Database Mirroring
Microsoft uses a few other concepts and technologies in database mirroring. You have already learned about the copy-on-write technology. Microsoft also uses endpoints, which are assigned to each server in a database mirroring configuration. In addition, establishing connections to each server is much more tightly controlled and requires service accounts or integrated (domain-level) authentication. Within SQL Server, grants must also be given to the accounts that will be executing database mirroring.
You can completely set up database mirroring by using T-SQL scripts, or you can use the Database Mirroring Wizard within SQL Server Management Studio (SSMS). We always advise that you use something that ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
