SQL server 2005 with Win Server 2008

Question

question

Troy_2012 asked Nov 2, '12

SQL server 2005 with Win Server 2008

Dear All, Is there any compatibility or known issues If I want to install Sql Server 2005 64bit with SP2 on Windows Server 2008 64bit SP2.

sql-server-2005 installation windows-2008

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2012-11-02T08:43:59Z

Magnus Ahlkvist answered Nov 2, '12

Second Google result for "SQL Server 2005 on Windows Server 2008": http://support.microsoft.com/kb/936302

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Troy_2012 commented · Nov 02, 2012 at 09:02 AM

Thank you very much for quick respond....How about Mirror technique ?

0 ·

Answer 2 · 2012-11-02T09:18:57Z

ramesh 1 answered Nov 2, '12

mirroring is a high availabilty option available from sql server 2005,and you can configure database mirroring if you have Standard or Enterprise edition

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Troy_2012 commented · Nov 02, 2012 at 09:29 AM

Dear ramesh I mean compatibility or known issues with Mirror technique W2k8 and SQL2k5 64bit enterprice.

0 ·

Answer 3 · 2012-11-02T09:45:58Z

Tim answered Nov 2, '12

SQL 2005 is supported on Windows Server 2008R2 and works fine, however I would recommend at least applying SP4 instead of SP2. As for mirroring it was supported beginning with SQL 2005 SP1. Great job on choosing 64bit.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question