Keith Starr
asked on
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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:
Is this the correct method to move databases from 2000 to 2008?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
ASKER
I didn't purposefully put it in single user mode. Wonder why that happened. Is there an easy way to change it?
ASKER
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.MSSQLSER VER\MSSQL\ DATA\maste r.mdf;-eC: \Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSER VER\MSSQL\ Log\ERRORL OG;-lC:\Pr ogram Files\Microsoft SQL Server\MSSQL10_50.MSSQLSER VER\MSSQL\ DATA\mastl og.ldf
-dC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSER
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!