'This server supports version 612 and earlier' failover problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » 'This server supports version 612 and...

'This server supports version 612 and earlier' failover problem

Rate Topic

Display Mode

Topic Options

Author

Message

millnerj

Posted Tuesday, December 18, 2012 6:54 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, December 22, 2012 8:11 AM
Points: 2, Visits: 155

We upgraded a SQL2K5 standard edition cluster to 2K8. Now receive error during failover "The database 'master' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported."

Each node displays the proper version and runs fine but will not accept failover from the failing node. It appears each node thinks it's still running 2K5 and won't accept a 2K8 master db. I'm guessing we did not install on passive node but installed on active node instead.

Any thoughts on how to fix this since now we can't failover and get any node passive?

Post #1398112

Posted Wednesday, December 19, 2012 2:13 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 299, Visits: 482

millnerj (12/18/2012)

Each node displays the proper version and runs fine

Where did you see this? Did you properly do "Add Node" in passive node?

Post #1398243

millnerj

Posted Wednesday, December 19, 2012 5:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, December 22, 2012 8:11 AM
Points: 2, Visits: 155

Saw the error message in the application event log.
Didn't add a node. Just upgrading two existing instances on the cluster.
Or, I don't understand your question.

Post #1398325

Posted Thursday, December 20, 2012 11:28 PM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 299, Visits: 482

Please verify your upgrade process with this link.
http://msdn.microsoft.com/en-us/library/ms191295(v=sql.105).aspx

Post #1399208

SQLRNNR

Posted Friday, December 21, 2012 1:04 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

Your databases have been upgraded but it does not appear that the cluster upgrade has been completed. Check the link provided and verify your setup.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1399239

dan-572483

Posted Friday, December 28, 2012 12:34 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 5:23 PM
Points: 330, Visits: 945

My guess is that the upgrade was not completed on the passive node, and a 2008 Master database cannot launch on a 2005 server.

Go to C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log on each node and compare the contents, particularly the most recent folders & files.

Post #1401014

« Prev Topic | Next Topic »

Permissions