question

Troy_2012 avatar image
Troy_2012 asked

Mirror technique with SQL and Windows

Dear All, If I have the Principal Server - SQL Server2005 Enterprise - Windows Server 2008 Enterprise R2 64bit Mirror Server - SQL Server2005 Enterprise - Windows Server 2008 Enterprise R2 64bit. Witness Server - SQL Express 2005 Q1)For Mirroring technique can we use SQLServer Enterprise 32bit in Principal Server and Mirror Server ...I know the 64bit is the better choice ? Q2) A- Can we use the Windows 2003 on Witness Server or it should be Windows Server 2008? B- If the Answer for A is windows server2008 Can we use the standard 32 or 64 or Enterprise 32 or 64? Q3) For Principal and Mirror Do we need the operating system Should be the same like Enterprise - Enterprise or Enterprise - standard.
sql-server-2005installationwindows-2008windows-2003
10 |1200 characters needed characters left characters exceeded

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

1 Answer

· Write an Answer
Kev Riley avatar image
Kev Riley answered
Q1 - Yes you can use Enterprise 32bit Q2 - Yes you can use Windows 2003 for the witness Q3 - Technically I think you can have differing OS, as long as the database edition matches, but practically you would want to keep them the same. The key to database mirroring is that the principal and mirror must be the same edition, and asynchronous is only supported in Enterprise Edition SP1. The witness server can be Express SP1, Workgroup SP1, Standard or Enterprise. The full list of supported operating systems is here : http://msdn.microsoft.com/en-us/library/ms143506%28v=sql.90%29.aspx Database Mirroring support detailed here: http://msdn.microsoft.com/en-us/library/ms189852%28v=sql.90%29.aspx
10 |1200 characters needed characters left characters exceeded

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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