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.

more ▼

asked Nov 26, 2012 at 04:16 PM in Default

avatar image

770 36 41 45

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Nov 27, 2012 at 09:11 AM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 26, 2012 at 04:16 PM

Seen: 900 times

Last Updated: Nov 27, 2012 at 09:17 AM

Copyright 2018 Redgate Software. Privacy Policy