Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 Mirroring Expand / Collapse
Author
Message
Posted Friday, August 21, 2009 5:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 25, 2009 6:30 AM
Points: 2, Visits: 11
Hi all,

I have a SQL 2008 DB mirror and wanted to add a SQL 2005 witness server. It looks like this is not working. A received an error 1456.
Also with an SQL 2008 witness it was not working, until I patched the witness to exact the same version as the both DB servers.

Anyone familiar with this behavior?

Thanks
Klaas
Post #774923
Posted Friday, August 21, 2009 5:22 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 3:22 AM
Points: 3,906, Visits: 1,098
Check the following link

http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/88e9ebfa-6378-40b9-844e-fcd0266a66a6



Post #774930
Posted Friday, August 21, 2009 5:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 25, 2009 6:30 AM
Points: 2, Visits: 11
vyas (8/21/2009)
Check the following link

http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/88e9ebfa-6378-40b9-844e-fcd0266a66a6


Hi vyas, thanks for your reply.

I have 2 different versions, not different editions. I think that this is not an answer on my question.

Klaas
Post #774937
Posted Thursday, June 27, 2013 3:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 1, 2014 10:01 AM
Points: 7, Visits: 9
Configure SQl mirror with following reference....

MS SQL 2008 Server Mirroring Guide..... http://mytecharticle.com/?p=279
Post #1468034
Posted Thursday, June 27, 2013 3:28 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, November 20, 2014 2:50 AM
Points: 608, Visits: 1,052
you can use 2008 express edition as a witness instead of using 2005..
Edition do not matter for witness server but versions do matter.


Pramod
SQL Server DBA | MCSA SQL Server 2012

in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
Post #1468049
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse