SQL 2000 to 2008 migration questions

I have an old server with Windows Server 2003 Standard x86 running SQL Server 2000 SP1. I have another server with Windows Server 2008 R2 Enterprise x64. I am going to install SQL Server 2008 Standard on the 2008 server and migrate the databases from the 2003 server. I've never done this before though I've read quite a bit on the subject. I did run the upgrade wizard with SQL 2008 and it came to the "Select Features" screen where both "Shared Features" and "Redistributable Features" were selected but greyed out. At the top it says, "It is not possible to change the SQL Server features to be upgraded in this release" and at the bottom it says, "There are no features selected for upgrade." What does that mean? I would have thought the upgrade wizard is the best way to upgrade. Not sure how to get past this part.
KeithADMAsked:
Who is Participating?
 
eridanixConnect With a Mentor Commented:
Hi,

I am not sure if there is any tool, which can do whole job for you.
In past, I was doing this process between MSSQL Server 2000 and 2005 and tutorial on this page was very helpfull for me.

http://twinklekumar.wordpress.com/2008/06/29/move-sql-server-2000-database-to-2005/

I used this tutorial and everything was without any problems.

Maybe, it should help you.
0
 
MrAliCommented:
Quick question,

Are you having a problem *installing* SQL Server 2008 on the machine on the 'shared components' screen, or are you having a hard time copying the database over?  

If it's copying the database over, I'd ask you to run the 'upgrade advisor' first, and see if there is any code that won't work in 2008, then we can do a backup/restore most likely in your scenario.  Let us know!
0
 
KeithADMAuthor Commented:
Okay, I've installed SQL 2008 R2 on the new server. Now, I'd like to backup the databases from SQL 2000 on my old server and restore them to SQL 2008 on the new server. I backed up one database from 2000 and tried to restore it in 2008, the error returned was:

System.Data.SqlClient.SqlError: Cannot restore any database other than master when the server is in single user mode. (Microsoft.SqlServer.Smo)

Is this the correct method to move databases from 2000 to 2008?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
eridanixConnect With a Mentor Commented:
When the SQL Server is in single user mode, only the master database can be restored.

Good expanation, how to reslolve it is this article:
http://www.symantec.com/business/support/index?page=content&id=TECH31277
0
 
MrAliCommented:
I'm not sure why your DB is in sinlge user mode in the first place, did you mean to put it in that mode?
0
 
KeithADMAuthor Commented:
I didn't purposefully put it in single user mode. Wonder why that happened. Is there an easy way to change it?
0
 
KeithADMAuthor Commented:
I checked the startup parameters, doesn't seem like it should be starting in single-user mode:

-dC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.