• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

Copy of Database Problem

Hi Everyone,

I am trying to copy over a database from one database server instance to another. The first instance containing the database is SQL Server 2005 and the one I want to transfer it to is SQL Server 2008.

I keep getting an error when I run the Copy Database Command. I was wondering if I could use a copy only backup to restore the database on the new server.

I am largely trying to see if anyone has encountered a similar situation.

Thanks for your help.

0
jonsuns7
Asked:
jonsuns7
1 Solution
 
mrjoltcolaCommented:
I've used detach in the past.

http://msdn.microsoft.com/en-us/library/ms189625.aspx

Detach it, copy it, then attach the copy to the 2008 instance and it will be upgraded in the process.
0
 
lcohanDatabase AnalystCommented:
I suggest use the "Upgrade Advisor to Prepare for Upgrades" before doing that and caution if you run it against production database as it may be resource intesive. You could also perform a FULL BACKUP then RESTORE to upgrade your DB to SQL2008 if you can't afford detaching it from the server.

http://msdn.microsoft.com/en-us/library/ms144256.aspx
0
 
Chris MangusDatabase AdministratorCommented:
What is the error you are receiving?
0
 
Alpesh PatelAssistant ConsultantCommented:
Go with Attach - Detach database or Backup Restore.
0
 
Alpesh PatelAssistant ConsultantCommented:
Please make sure back is full and database type also.
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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