Avatar of Allanore
Allanore
 asked on

Upgrading SQL 2008 to 2008 R2

I am upgrading SQL server 2008 to SQL server 2008 R2. I ran the Microsoft SQL Server 2008 R2 Upgrade Advisor tool and got the following after running it serveral times:

Each time the process returned errors that indicated the scan did not finish successfully. The process continued to fail around 48% and the only message i get is Deprecated SP. Timeout Expired. The timeout period elapsed prior to completeion of the oepration or the server is not responding.

SQL Server 2008 Standard Edition installed on WIndows Server 2008 SP2. Any ideas?
Microsoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Zberteoc

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Zberteoc

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Allanore

ASKER
Ended up talking to Microsoft on this one. The Deprecated SP error just means that their are features that will not be available in SQL 2008 R2. Microsoft support gave the go ahead to do the upgrade:

http://msdn.microsoft.com/en-us/library/ms143729(v=sql.100).aspx
Allanore

ASKER
I've requested that this question be closed as follows:

Accepted answer: 0 points for Allanore's comment #a39649047

for the following reason:

Spoke to microsoft support for answer.
Zberteoc

I also gave that solution and more...
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck