| Author |
 Topic  |
|
|
albertkohl
Aged Yak Warrior
USA
723 Posts |
 Posted - 07/10/2012 : 23:33:28
|
Okay, so here's a fun one. i just upgraded from SQL Server 2008 to 2012. everything w/ the upgrade when nicely. just rebooted the server, and guess what? my main DB is marked suspect.
so i set the db into emergency mode, and go to do a checkdb and i get:
Msg 946, Level 14, State 1, Line 1
Cannot open database 'MYDB' version 655. Upgrade the database to the latest version.
so now what?! |
|
|
albertkohl
Aged Yak Warrior
USA
723 Posts |
Posted - 07/11/2012 : 10:59:17
|
| anyone got any ideas? |
 |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
albertkohl
Aged Yak Warrior
USA
723 Posts |
Posted - 07/11/2012 : 13:51:42
|
| not right now :( i'm not terribly worried about the data as i was able to transfer it from another server, just seems like in this case unless you guys had any great ideas, i'd have to restore the entire o.s. from backup, or uninstall sql2k12, reinstall 2k8, HOPE that i mount/fix, and then try the upgrade again. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
albertkohl
Aged Yak Warrior
USA
723 Posts |
Posted - 07/11/2012 : 14:06:45
|
i've had issues in the past where if the db version is different, it wont install. (i.e. if i backed up db in 2k8 sp2, and tried to restore in 2k8 sp3, it wont let me) is there a way to override that?
just used the setup wizard and upgraded the db engine. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
albertkohl
Aged Yak Warrior
USA
723 Posts |
Posted - 07/11/2012 : 14:10:18
|
| so in this case, install a new 2012 instance, backup db's from 2008, restore to 2012, and then drop 2008 when happy? |
|
|
|
albertkohl
Aged Yak Warrior
USA
723 Posts |
Posted - 07/11/2012 : 14:14:40
|
| btw, anything i can do the force-repair the db i have an issue w/ i'd rather not have to create all the indexes, but if i need to, so be it. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
albertkohl
Aged Yak Warrior
USA
723 Posts |
Posted - 07/11/2012 : 14:41:17
|
| no backup on that db. (been doing all kinds of shuffling and what not, so backups are broken) like i said, it's not HUGE, but i would think there's a way to make sql run the check considering the db is mounted , and in emergency mode. if not, w/e. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
albertkohl
Aged Yak Warrior
USA
723 Posts |
Posted - 07/11/2012 : 15:01:47
|
| agreed :) the upgrade on the other server went oh so well though! :) live and learn... thanks again tara. any cool articles you can refer me to on new gnarly things for sql 2012? |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
| |
Topic |
|
suspect db after upgrade
