1. It is recommended to make a backup of the database upgrade to the production environment, safekeeping.
2. To upgrade from SQL Server R2 to SQL Server SP1, you need to install the SP1 or SP2 patch pack for SQL Server R2, where you run the installation of the SP2 fix pack that has been downloaded.
3. SQL Server R2 update run check,
4. Accept the license terms,
5. Select the function,
6. Check the files that are in use,
7. Ready to update, select "Update",
8. Update complete, select "Close",
9. Install the SP2 patch package and mount the SQL Server SP1 installation CD on the server.
10. Open SQL Server SP1 Setup, select "Install",
11. In the Installation dialog box, select "Upgrade from SQL Server 2005, SQL Server 2008, or SQL Server R2",
12. Check the installation program support rules
13. Enter the Product key,
14. Accept the license terms,
15. Select Install SQL Server product updates,
16. Downloading the installer file,
17. The update is being extracted,
18. Installing the Installer files,
19. The installer supports rule checking,
20. Select an instance,
21. Select the function,
22. Configure the instance,
23. Check disk space requirements,
24. Configure the service account,
25. In the full-Text Upgrade dialog box, select "Import",
26. In the Report error dialog box, select Next,
27. Check the upgrade rules,
28. Ready to complete, select "Upgrade" to start upgrading SQL Server
29. Upgrading SQL Server,
30. Complete the SQL Server upgrade,
31. Upgrade to complete SQL Server, now you need to validate the data in SQL Server, open the Microsoft SQL Server Management Studio tool,
32. Set whether custom user settings need to be imported from SQL Server Management Studio,
33. Enter the SQL Server server name, as you are logged on natively, enter localhost or 127.0.0.1 or the computer name,
34. Select "New Query",
35. Create a new query, execute SELECT @ @version view the SQL Server version
36. In the Query dialog box, perform
Select Top 5 * from [zxta].dbo. Y_ file
Select Count (*) from [zxta].dbo. Y_ file
View the data information in the database.
Ext.: http://www.68idc.cn/help/jiabenmake/qita/20150318285046.html
SQL Server R2 upgrade to SQL Server SP1