[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

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.
0
KeithADM
Asked:
KeithADM
  • 3
  • 2
  • 2
2 Solutions
 
eridanixCommented:
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 recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
eridanixCommented:
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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now