asked on
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
Microsoft SQL Server 2008Windows Server 2008Microsoft SQL Server 2005Microsoft SQL Server
Last Comment
MohammedU
ASKER
Can I please have some more links on step by step with screenshots.
Thanks
Thanks
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
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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