I have built and set-up 3 x servers - to perform the role of Principal, Mirror and Witness servers.
Principal and Mirror servers has SQL 2008 installed and configured, Witness has SQL 2008 R2 Express edition.
Step 1: Installed and configured SQL 2008 in Principal server and restored application database.
Now how to go about setting up DB mirroring and test the possible synchronous/asynchronous options. IS there any step by step documentation available?
Please advise.
Thanks and Regards
Microsoft SQL Server 2008Windows Server 2008Microsoft SQL Server 2005Microsoft SQL Server
http://www.sqlmag.com/article/sql-server/Database-Mirroring-in-SQL-Server-2008-and-SQL-Server-2008-R2/2.aspx
http://technet.microsoft.com/en-us/library/ms189047.aspx
https://www.experts-exchange.com/questions/26365449/SQL-SERVER-2008-R2-Mirror-problem.html