Link to home
Start Free TrialLog in
Avatar of JustinGSEIWI
JustinGSEIWI

asked on

SQL upgrade advisor help

I am going to try and upgrade SQL from 2005 to 2008 R2 next week. I have just ran the upgrade adviser and attached the report.

I am no SQL expert and don't know how to interpret this report or how to fix what it suggests.

I am only concerned with the WSS_content, MVGSC, GSEIW databases.

The primary reason I am doing this is because I need to upgrade Great Plains to 2013 from version 10 and it requites SQL 2008 instead of 2005.

Thanks,

Justin
sql-log.csv
sql-log1.csv
ASKER CERTIFIED SOLUTION
Avatar of Ryan McCauley
Ryan McCauley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JustinGSEIWI
JustinGSEIWI

ASKER

Thank you for the reply.

I ran it again and this time did not get the timeouts. The SQL server is a virtual server on ESXi5. I was running the test locally on the SQL server itself.

We are a simple shop and I see no need to change compatibility levels unless GP requires it for some reason.

Please let me know what you think of the new log file.

Justin
sqlloggp.csv
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So to confirm, the items pointed out with SQL update adviser would only be an issue if I upgrade my compatibility level? How do I confirm the compatibility level of my databases?

Then I am fine with ignoring the flagged items in the logs i posted? If I needed to, how would I go about resolving the items that were flagged?

Thanks,

Justin
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I checked the compatibility level for all databases. Most of them are 90 with a couple set to 80. So it looks like I can safely upgrade from 2005 to 2008 R2 with no trouble right?

I am creating a copy virtual machine of my production SQL server tonight. Then I will use the copy to do a test upgrade early next week and see how it goes.

Anything else you can think of that would be helpful for me to know during this upgrade?

Thanks again!

Justin
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial