There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
SQL 2008 DB Mirroring set-up
Hello experts,
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
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
Asked:
2
1 Solution
http://www.databasejournal.com/features/mssql/article.php/3828341/Database-Mirroring-in-SQL-Server-2008.htm
http://blogs.msdn.com/b/sqlserverfaq/archive/2009/03/31/setting-up-database-mirroring-in-sql-server-2008-using-t-sql-when-the-database-is-encrypted-using-transparent-data-encryption.aspx
http://sqlserver.in/blog/index.php/archive/database-mirroring-step-by-step/
http://sqlserver-training.com/how-to-set-up-database-mirroring-in-sql-server-2008-video/-
http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx
http://blogs.msdn.com/b/sqlserverfaq/archive/2009/03/31/setting-up-database-mirroring-in-sql-server-2008-using-t-sql-when-the-database-is-encrypted-using-transparent-data-encryption.aspx
http://sqlserver.in/blog/index.php/archive/database-mirroring-step-by-step/
http://sqlserver-training.com/how-to-set-up-database-mirroring-in-sql-server-2008-video/-
http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
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
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_26365449.html