Link to home
Start Free TrialLog in
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?
ASKER CERTIFIED SOLUTION
Avatar of Zberteoc
Zberteoc
Flag of Canada 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 Allanore
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
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.
I also gave that solution and more...