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

'This server supports version 612 and earlier' failover problem Expand / Collapse
Author
Message
Posted Tuesday, December 18, 2012 6:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
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
Posted Wednesday, December 19, 2012 5:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
Please verify your upgrade process with this link.
http://msdn.microsoft.com/en-us/library/ms191295(v=sql.105).aspx
Post #1399208
Posted Friday, December 21, 2012 1:04 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 17,967, Visits: 15,975
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1399239
Posted Friday, December 28, 2012 12:34 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 2:39 PM
Points: 556, Visits: 1,635
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 »

Add to briefcase

Permissions Expand / Collapse