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, 2009 at 01:55 PM in Default

avatar image

Stuart Grace
33 1 1 3

(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, 2009 at 03:07 PM

avatar image

John Sansom
897 2 4

(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 03, 2009 at 01:55 PM

Seen: 3220 times

Last Updated: Nov 04, 2009 at 08:04 AM

Copyright 2016 Redgate Software. Privacy Policy