The sqlserver 2008 R2 version of the problem

I attach a database times such mistakes:
Database 'test' version is 661, cannot open. This server supports version 655 and earlier. Degradation paths are not supported.
Unable to open the new database'QPAccountsDB'. CREATE DATABASE stop. (Microsoft SQL Server, error: 948)

So I upgrade to the R2 database, are successful, in the help - "on the display version is Microsoft SQL Server Management Studio 10.50.4000.0
But with the select @@version or Microsoft SQL Server 2008 display version (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

Started by Harley at November 14, 2016 - 7:16 PM

The upgrade is complete, restart you try again?

Check whether there are multiple instances of SQL?

Posted by Cheney at November 25, 2016 - 8:01 PM

No use of such, I from 08 to upgrade to R2 later, also installed the SP1 patch, I have only one instance of SQL, from
See is normal, but from the select @@version look into
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)

There is no way to restore the R2 backup

Posted by Kate at November 28, 2016 - 8:44 PM

You will not only upgrade the SSMS without upgrading the SQL Engine.?

Posted by Harry at December 13, 2016 - 8:46 PM

@Small deciduous.
Excuse me, is it right? From here to upgrade?

Posted by Cheney at December 24, 2016 - 8:58 PM

See your SELECT version of the result is not to upgrade, or as the moderator said no upgrade instances.

Posted by Silvester at January 07, 2017 - 9:11 PM