Recently a friend consulted the SQL Server upgrade issue, in the test environment to upgrade SQL Server R2 to SQL Server SP1, because it is in the test environment, so before the upgrade of the database server is not backed up, It is recommended that you do a backup of the database upgrade to the production environment before safekeeping.
Now get to the point and start upgrading SQL Server R2 in the following steps:
First open the Microsoft SQL Server Management Studio tool, create a new query, and execute SELECT * FROM dbo. Y_ file, confirm the data information in SQL Server,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/68/wKiom1UH7DbiWj8IAAGv-R3zjPI840.jpg "/>
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.
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/62/wKioL1UH7V_yJZsMAAFT285phz0943.jpg "/>
3. SQL Server R2 update run check,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/68/wKiom1UH7DiCymxWAAFEhg7pW3o085.jpg "/>
4. Accept the license terms,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/68/wKiom1UH7DmQ_rokAAG4OoX-AM4852.jpg "/>
5. Select the function,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/62/wKioL1UH7WLABg1rAAFmmrci9_A611.jpg "/>
6. Check the files that are in use,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/68/wKiom1UH7DqBoYCIAAEQ_VDsee4359.jpg "/>
7. Ready to update, select "Update",
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/62/wKioL1UH7WPA_iLoAAFQdZ42A6k881.jpg "/>
8. Update complete, select "Close",
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/68/wKiom1UH7DyDuBi5AAEZ9mB6YCc079.jpg "/>
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",
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/62/wKioL1UH7WSyeaHVAAHsNt0cuH0032.jpg "/>
11. In the Installation dialog box, select "Upgrade from SQL Server 2005, SQL Server 2008, or SQL Server R2",
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/68/wKiom1UH7D3z3CDXAAFz1025Nwo135.jpg "/>
12. Check the installation program support rules
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/62/wKioL1UH7WaBFMUgAAD3iGtn55k401.jpg "/>
13. Enter the Product key,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/62/wKioL1UH7WbRXK35AAEa8s8gEbg234.jpg "/>
14. Accept the license terms,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/62/wKioL1UH7WjShxvnAAGd70sZaig548.jpg "/>
15. Select Install SQL Server product updates,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/68/wKiom1UH7EGAhZNhAAE6sJ9vN4s165.jpg "/>
16. Downloading the installer file,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/68/wKiom1UH7EOTWLKnAAExzPLSxhw263.jpg "/>
17. The update is being extracted,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/62/wKioL1UH7Wug4OJHAAEclwHEZhk335.jpg "/>
18. Installing the Installer files,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/62/wKioL1UH7WuTtUDHAAEqBzbantM056.jpg "/>
19. The installer supports rule checking,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/68/wKiom1UH7ETzjc-9AAEgzJfgnBU791.jpg "/>
20. Select an instance,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/68/wKiom1UH7EbhOyHUAAFMD3OWFeY626.jpg "/>
21. Select the function,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/62/wKioL1UH7XDS8lScAAF4_9FOedI722.jpg "/>
22. Configure the instance,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/68/wKiom1UH7ErxkaRgAAHOaPFtIB8943.jpg "/>
23. Check disk space requirements,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/62/wKioL1UH7XLyjR4gAAEZYhUx4G4020.jpg "/>
24. Configure the service account,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/68/wKiom1UH7EuD3ZTJAAFBfP1wY4Q875.jpg "/>
25. In the full-Text Upgrade dialog box, select "Import",
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/62/wKioL1UH7XTjslcCAAGJMddPtrU243.jpg "/>
26. In the Report error dialog box, select Next,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/68/wKiom1UH7E3QYxJPAAF-S0r-L24327.jpg "/>
27. Check the upgrade rules,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/62/wKioL1UH7XXTQ5I8AAEqbk-7-KQ741.jpg "/>
28. Ready to complete, select "Upgrade" to start upgrading SQL Server
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/68/wKiom1UH7E-RL1XFAAGpanFmaYI976.jpg "/>
29. Upgrading SQL Server,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/62/wKioL1UH7XeB_MYWAADcUo2DxeA593.jpg "/>
30. Complete the SQL Server upgrade,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/68/wKiom1UH7FHiAB14AAHmubUWz6E185.jpg "/>
31. Upgrade to complete SQL Server, now you need to validate the data in SQL Server, open the Microsoft SQL Server Management Studio tool,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/62/wKioL1UH7Xqj-DGCAAG8KsquL_A403.jpg "/>
32. Set whether custom user settings need to be imported from SQL Server Management Studio,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/62/wKioL1UH7XuiepjbAAFs8YyG5Tw315.jpg "/>
33. Enter the SQL Server server name, as you are logged on natively, enter localhost or 127.0.0.1 or the computer name,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5B/68/wKiom1UH7FTiBtp_AADZnIZQ-70502.jpg "/>
34. Select "New Query",
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/62/wKioL1UH7XzxUEgRAACTacKOnxc287.jpg "/>
35. Create a new query, execute SELECT @ @version view the SQL Server version
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5B/68/wKiom1UH7FTCWzfEAAD6_E3nckA896.jpg "/>
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.
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5B/62/wKioL1UH7X2j_0BYAAGNuwY4fo8573.jpg "/>
Validated, SQL Server upgrade succeeded!
This article is from the "Zlyux" blog, make sure to keep this source http://zlyux.blog.51cto.com/1654149/1621512
SQL Server R2 upgrade to SQL Server SP1