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

Rahul Agarwal

Please read the Links:

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

goprasad

ASKER

Can I please have some more links on step by step with screenshots.
Thanks

MohammedU

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

ASKER CERTIFIED SOLUTION

MohammedU

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial