SQL Server R2 upgrade to SQL Server SP1

Source: Internet
Author: User
Tags pack management studio microsoft sql server management studio sql server management sql server management studio

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.