Solved

Trouble Upgrading SQL 2000 to SQL 2008 R2 SP1

Posted on 2012-03-19
3
784 Views
Last Modified: 2012-08-14
We are running SQL 2000 on Windows serer 2003. Currently we are only utilizing one database; which is for our time and attendance system. We have a custom SQL application that requires SQL 2005 or newer, so we purchased SQL 2008 R2 SP1.

I obtained my ISO from Microsoft for SQL 2008 R2 SP1. I opened it using Magic Disk, and was able to extract the 3 Executables, SQL 2008 x86, x64, and IA64. I'm attempting to install using x86.

During install of Microsoft SQL Server 2008 R2 Service Pack 1...SQL Server 2008 R2 update, select next. Licensing Terms, next. Select Features (blank), select next. Then i get an error. There are validation errors on this page. Click OK to close this dialog box. Review errors at the bottom of the setup page, then provide valid parameters or click help for more information.

At the bottom of the screen, i see the message: There are no SQL Server Instances or shared features that can be updated on this computer.

I have also attempted to upgrade using SQL 2008 SP3. Same results.
0
Comment
Question by:mray77
  • 2
3 Comments
 

Author Comment

by:mray77
ID: 37739247
Am i better off simply doing a full install of SQL 2008 R2 SP1 and importing my SQL 2000 database?
0
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 37739262
You can't upgrade from SQL 2000 to 2008 directly and yes, you would be better off to install SQL 2008, then use detach/attach or better(safer) backup/restore from 2000 to 2008.
I suggest you also script all SQL logins from old SQL 2000 and create then on the new SQL 2008 as logins are at SQL level but inside SQL dbs as well.
0
 

Author Closing Comment

by:mray77
ID: 37739327
Perfect. Thanks for the info!
0

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question