December 1, 2010 at 7:59 am
I'm running a test to see if mirroring between SQL2008 SP1 and SQL 2008 R2 works successfully.
I configured a Sync mirror with SQL2008 SP1 as the principal and SQL 2008 R2 as the mirror.
I successfully failed over over the mirror to the SQL 2008 R2 server (alter database yada set partner failover) and the principal is now on the SQL 2008 R2 instance.
The database is operational.. Unfortunately, the mirroring state is Suspended... when I manually try to resume the mirror, i receive the following error in the SQL error log:
error 948, status 2, severity 20
Database mirroring has been suspended. Resolve the error on the remote server and resume mirroring, or remove mirroring and reestablish the mirror server instance.
Interesting Part - I spent an hour at the PASS conference with Microsoft regarding mirroring. Microsoft was adamant that SQL mirroring works fine between SQL 2008 SP1 and R2.
Has anyone been successful with getting mirroring configured and working properly with the R2 instance acting as the principal and SP1 as the mirror (actually synchronized)?
December 1, 2010 at 8:04 am
I don't believe that's possible. Those are two different versions of SQL. It's like trying to mirror SQL 2008 to SQL 2005.
The only time mirroring with different versions is supported (afaik) is during a rolling upgrade (and in that case I believe that the mirror has to be upgraded first)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2010 at 8:39 am
I checked with a couple of people. Mirroring 2008 -> 2008 R2 is possible, the reverse is not. The mirroring of different versions is only for rolling updates, not for a permanent config. The 1st rule of mirroring is identical versions on both sides (down to service pack and CU level)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2010 at 8:52 am
I was really skeptical when discussing with Microsoft mirroring between SP1 and R2.
The Microsoft tech folks at the PASS SQL Clinic were in complete agreement that mirroring between SP1 and R2 should work properly.
Oh well - now it's confirmed, that it doesn't work!
Thanks.
December 1, 2010 at 8:58 am
I would expect that behavior. It works uplevel, but not downlevel.
Mirroring is built for HA/DR, which means that you are trying to protect your data with another copy. I'd think that would mean that you wouldn't try to push the envelope here. You want your system to be safe.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 1, 2010 at 9:28 am
You can only use database mirroring to upgrade from SQL 2008 to SQL 2008 R2. It lets you mirror from the old version to the new version, and then failover once to upgrade. It is a one way trip that works very well for that purpose only.
November 4, 2011 at 12:00 pm
Hello,
I am working on a SQL 2008 database mirroring solution. The current production is SQL 2008 SP2 running on Windows 2008 SP1 and plan is to build a mirror instance on SQL 2008 R2 and after the principal-mirror partner-to-partner quorum is set up, we plan to go back and upgrade SQL01(the principal) to SQL 2008 R2.
Please could you let me know if this is possible?
Highly appreciate your inputs.
Regards,
Abhijit
March 15, 2012 at 10:08 pm
can we setup an mirror for standard to enterprise or another way?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply