Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Robowski
Posting Yak Master
101 Posts |
 Posted - 2013-05-28 : 10:26:41
|
| I downloaded the 2008 db from here http://msftdbprodsamples.codeplex.com/releases/view/105902But when I try to attach it to a 2008 R2 server I get an error saying the db version is 655 but this server supports version 612.Surly 2008 R2 SP 2 will attach any db below 2012?CheersRob |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-28 : 10:44:59
|
That sounds like an error message you would see if you tried to attach a 2008 database to a SQL Server 2005. I am not trying to insult your intelligence, but open a query window and try this to just double-checkSELECT @@version; |
 |
|
|
Robowski
Posting Yak Master
101 Posts |
Posted - 2013-05-28 : 11:03:01
|
| It shows as 2005 so obviously that's why but when I do help, about it shows as SQL server 2008 R2.I wasn't aware of SELECT @@Version, thought help > about would tell me the exact.I'm assuming this works PC previously had 2005 on it then but the upgrade didn't upgrade the local server, just the client? |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-28 : 11:14:27
|
| Yes, that does seem like the SSMS is 2008 R2, but the server is not. In the object explorer window, when you connect to a server, it shows the name of the server and theversion. 10.5.xxxx is 2008 R2 and 9.0.xxxx is 2005. |
|
|
|
Robowski
Posting Yak Master
101 Posts |
Posted - 2013-05-29 : 04:27:23
|
| It never shows a name, just 9. I've re-installed now and all is fine. I'll remember SELECT @@version, thanks! |
|
|
|
|
|
|
Restore error