Implementing SQL 2008 database mirroing

Question

Hello Team,

I am new to SQL product. We have brought sql server 2008 standard edition. Planning to deploy high availability. Found that there are two way like database mirroing and clustering.

Could you please let us know which technology will be supported in sql server 2008 standard edition and what 2008 R2 OS edtion we need to perform the same.

Also please provide some detail information to explain step by step on installing it. We are using SQL 2008 as the backend for SCOM 2007 , SCVM 2007 and Lync 2010.

---

Exchange Queries

Answer 1

http://blogs.msdn.com/b/tommills/archive/2010/06/02/new-sql-server-2008-r2-high-availability-whitepaper-published.aspx

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

Here are two links to the post on how to configure database mirroring:

http://sudeeptaganguly.wordpress.com/2012/03/06/database-mirroring-with-sqlcmd/

http://sudeeptaganguly.wordpress.com/2010/07/25/how-to-configure-database-mirroring-in-an-active-directory-environment-using-sql-server-2008/

Windows Server 2008 R2 comes in only x64 version.

Hope, it may be helpful.

---

SKG: Please Marked as Answered, if it resolves your issue. b: http://sudeeptaganguly.wordpress.com

Answer 3

I want to know what edition of OS either standard edition windows server 2008 r2 or Enterprise edition of windows server 2008 r2  support SQL database mirroring in sql standard edition...

Sudeepta i want detail about edtion not the version...i know there is only 64bit os in Win2k8.. :)

---

Exchange Queries

Answer 4

Database Mirroring is a feature of SQL Server not the OS... It is supported by EE and STD on all Windows Server Editions

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 5

Lync Server does not support database mirroring:
http://technet.microsoft.com/en-us/library/gg398990.aspx

You will have to use failover clustering which requires Windows Server Enterprse Edition and either shared storage or 3rd party cluster integrated data replication software. 

Here are some resources:

Create a New SQL Server Failover Cluster (Setup):
http://msdn.microsoft.com/en-us/library/ms179530.aspx

Step-by-Step: Configuring a 2-node multi-site cluster on Windows Server 2008 R2 – Part 3:
http://clusteringformeremortals.com/2009/10/07/step-by-step-configuring-a-2-node-multi-site-cluster-on-windows-server-2008-r2-%E2%80%93-part-3/

---

David A. Bermingham, MVP, Senior Technical Evangelist, SIOS Technology Corp

Answer 6

Thanks David you provide me more detail information which has helped me a lot...

Will SQL 2008 R2 SP1 standard edition support this failover clustering...??

---

Exchange Queries

Answer 7

Yes, SQL Standard Edition supports up to a 2-node cluster.

---

David A. Bermingham, MVP, Senior Technical Evangelist, SIOS Technology Corp