SQL 2008 upgrade to SQL R2. Speaking of why upgrade is because, from another machine backed up a database, to my machine when the restore prompt "948 error, meaning that the high version of the database can not be attached to the lower version, so to upgrade their version of the database." Note: 10.00.1600 is actually SQL 2008 10.50.1600 is actually SQL r2 10.50.2500 is actually SQL R2 sp1 first step: Prepare to install the program. First, SQL 2008 is installed, so just download the SQL R2 installer, as follows: http://care.dlservice.microsoft.com/dl/download/1/E/6/ 1e626796-588a-495c-917b-321093fb98eb/2052/sqlfull_x86_chs.exe?lcid=2052&ptype=pcare Step two: Upgrade starts. SHOW time!!! 1, if you upgrade from SQL2008 to sql2008r2 then you can only select the left "install" corresponding to the right "from SQL SERVER 2000,sql 2005 or SQL 2008 Upgrade" This option to upgrade. (It is also noted that there is a "maintenance" but this option is "upgraded from SQL 2008 Other such as Express version" in this, to differentiate clearly. 2. The Setup program supports rule checking. Proceed to the next step after passing it. 3, enter the product key, this place, your key is what version, after loading your database is what version: Like Enterprise version, development version and so on. (EG:PTTFM-X467G-P7RH2-3Q6CG-4DMYB) 4, accept the License Terms 5, the installation program support files. 6, program support rules after the installation of the program will automatically detect whether the installed files meet the requirements. 7, when you have only one instance of the server, you can hardly hear the word instance, people call him "database" directly. Only when you have more than two instances installed on the server can you hear the word "instance" more. But "instance" is definitely the place to be known in the Learning database process, select the instance you want to upgrade. The next step would be fine. 8, previously installed components (component) will appear here, no tube, before, and now of course, have to, close your eyes click "Next" Bar! 9, because is the upgrade installs, so your previous instance name is what, here still is whatYou. Continue to "next". 10, whether to send error report, casually, next. 12, "Next". 13. Click "Upgrade" button to upgrade, wait about 20-30 minutes to complete.  14 During the upgrade process, the installation successfully requires a reboot. Restart it, no, say it!! 15, restart, start ssms (SQL SERVER MANAGEMENT STUDIO) in the login interface will be immediately aware of the difference, SQL 2008 became SQL R2. 16, connected to the database engine, You can see the version of your database in the left navigation bar. This time it became 10.50.1600. If you also want to upgrade to 10.50.2500. Then go ahead and install an upgrade patch! At this point, 10.00.1600 upgrade 10.50.1600 has been successfully completed. To summarize: 10.00.1600 is SQL Server 200810.50.1600 is SQL Server R2 This it is about the upgrade installation, if you want to do a clean installation, please do the following: First, uninstall SQL Server 2008, be sure to uninstall, the database is not like other common applications (those programs will automatically detect if there is an older version, then uninstall and upgrade to you). Another: For SQL, if you install it, and then install it again, actually install another instance. Second, after unloading the installation will be done. The installation---a fresh installation is performed.
sql_server_2008 ways to upgrade SQL_SERVER_2008_R2