x

DB Mirror with SQL Server 2008 Principal and Mirror, SQL Server 2005 as the witness

Is it possible to have two SQL Server 2008 standard servers that are going to be mirrored (the partners), using a SQL Server 2005 standard server as the witness.

more ▼

asked Nov 03 '09 at 01:55 PM in Default

Stuart Grace gravatar image

Stuart Grace
33 1 1 1

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

1 answer: sort voted first

From reading books online I would say yes.

It looks as though you can run a Principal and Mirror using SQL 2008, whilst using a Witness server on SQL Server 2005 or above.

Taken from SQL Server 2008 Books Online (October 2009):

Software and Hardware Recommendations

We strongly recommend that the witness reside on a separate computer from the partners. Database mirroring partners are supported only by SQL Server 2005 Standard and later versions and by SQL Server 2005 Enterprise Edition and later versions. Witnesses, in contrast, are also supported by SQL Server 2005 Workgroup and later versions and by SQL Server 2005 Express Edition and later versions. A witness can run on any reliable computer system that supports any of these editions of SQL Server. However, we recommend that every server instance that is used as a witness correspond to the minimum configuration that is required for the SQL Server Standard version that you are running. For more information about these requirements, see Hardware and Software Requirements for Installing SQL Server 2008.

For full reference details see: Database Mirroring Witness

more ▼

answered Nov 03 '09 at 03:07 PM

John Sansom gravatar image

John Sansom
897 2

As he said... just adding that its a cheap practice to use an express edition of sql server 2005/2008 as witness.

Another detail is that, if using sql server 2005, you need at least SP2 if i am correct.
Nov 03 '09 at 08:19 PM Gustavo
(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1933
x1816
x56

asked: Nov 03 '09 at 01:55 PM

Seen: 2769 times

Last Updated: Nov 04 '09 at 08:04 AM