Showing posts with label google. Show all posts
Showing posts with label google. Show all posts

Thursday, March 22, 2012

Database Mirroring

Hi All,
Does anybody know the OS requirements for Database Mirroring? I checked BOL and Google but couldn't find any info on that.
Thanks.http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirfaq.mspx

Q.What are the different licenses available for mirroring?
A.The witness can be any edition of Microsoft SQL Server 2005.
If a partner uses the SQL Server 2005 Standard Edition, the safety must be FULL, and REDO is single-threaded.
In SQL Server 2005 Enterprise Edition, the feature is fully implemented, and lets you turn the safety OFF and have REDO multithreaded.

SQL Server 2005 Std is supported on:
Microsoft Windows 2000 Server with Service Pack (SP) 4 or later; Windows 2000 Professional Edition with SP 4 or later; Windows XP with SP 2 or later; Windows Server 2003 Enterprise Edition, Standard Edition, or Datacenter Edition with SP 1 or later; Windows Small Business Server 2003 with SP 1 or later
http://www.microsoft.com/sql/editions/standard/sysreqs.mspx

SQL Server 2005 Enterprise is supported on:
Microsoft Windows 2000 Server with Service Pack (SP) 4 or later; Windows Server 2003 Standard Edition, Enterprise Edition, or Datacenter Edition with SP 1 or later; Windows Small Business Server 2003 with SP 1 or later
http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx

-a|||Do the OS requirements change based on the database high availability option you select?|||Don't be lazy, read the links I posted. The answers are in there.|||Thanks for the info.|||No problem :)