Register
Home   Ask Question Discuss Purchase Submit Events Give Solutions Share News
Automobiles Beauty & Styles Business Computers & Internet Sports Travel Consumer Electronics Education Entertainment & Music Family Society & Culture Food & Drinks Health
Computer Networking
Hardware
Internet
Programming & Design
Security
Software
Other - Computers
Steps by Steps guide on how to upgrade to SQL 2008 R2
-->

Steps by Steps guide on how to upgrade to SQL 2008 R2.

1. Before upgrading to Microsoft SQL 2008 to SQL 2008 R2 run the Upgrade Advisor. Upgrade Analyzer is part SQL server 2008 R2 feature pack or you can download it from here http://www.microsoft.com/en-us/download/details.aspx?id=16978

2. It will analyze following services

· Database Engine

· Analysis Services

· Reporting Services

· Integration Services

· Data Transformation Services

3. The analyzer will show the report. If there is any errors or some tasks that need to be completed before starting the upgrade, please follow the analyzer report and resolve it.


Upgrading to SQL 2008
R2

1. Insert the SQL Server installation media, and from the root folder, double-click Setup.exe

2. Click on installation on the left pane. You will see below screen

3. Click on , Upgrade from SQL Server 2000, SQL Server 2005, or SQL Server 2008.

4. You should see below screen once the Support Rules are success. If you see error please click on the link of the error message an resolve the issue before proceeding ahead.

5. Click on ‘OK’ button

6. Provide your Product Key in the Text box. See the image below.

7. Next, Accept the License Terms. Click Next

8. On the Next screen, Please ‘Install’

9. You might receive the message to restart the machine. Please click on OK and restart.

10. Next you will see below screen. Click Next

11. Next, specify the instances that you want to upgrade to. Select from the drop down box. Click Next

12. Select features from the box and click Next

13. On next screen verify your configuration. Click Next

14. Check that you have sufficient Free space on the drive

15. Provide the service account details. Recommended is that you use different account for each services

16. Select Authentication method, whether ‘Windows’ or ‘Mixed Mode’

17. On the error Reporting window Click Next.

18. The System Configuration Checker will run one more set of rules to validate your computer configuration with the SQL Server features that you have specified before the upgrade operation begins.

19. On the Rule Upgrade window, it will verify the upgrade requirement, please make sure that all the rules are ‘Passed’. Click Next.

20. Next on the ‘Ready to Upgrade’ window click Upgrade

21. Once the upgrade wizard complete, you will see below screen

--
Bookmark and Share
Related Posts
Comments
Add Comment
Name*
Email*
Comment*
Hot Categories: Hardware Celebrities Singles & Dating Other - Business & Finance Marriage & Divorce General Health Care Other - Family & Relationships Community Service
Contact Us About Us Privacy Policy Copyright Sitemap