SQL 2008 Upgrade Advisor

SQL Server 2008 Upgrade Advisor

After installing the SQL Server 2008 Upgrade Advisor, Open the utlility by double clicking on it.

It will open the window as shown below,

UA-1

On click of “Launch Upgrade Advisor Analysis Wizard”, it will open a window as shown below,

UA-2

Click the next button it will open another window,

UA-3

The server name will be loaded by default. If you want to trace another instance you can give the server name.

Tick the check box what components you are going to trace and click next button,

UA-4

Give user name and password or select windows authentication.

UA-5

Select the database you want to trace and click next

UA-6

Click Run, it will start analyse your database.

Once analysis is complete then click launch report.

UA-7

This is the result what you get once you click the Launch Report

Upgrade Advisor Report-2

Upgrade Advisor Report

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s