Copy of Database Problem

Posted on 2011-05-02
Last Modified: 2012-05-11
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.

Question by:jonsuns7
    LVL 40

    Expert Comment

    I've used detach in the past.

    Detach it, copy it, then attach the copy to the 2008 instance and it will be upgraded in the process.
    LVL 39

    Accepted Solution

    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.
    LVL 17

    Expert Comment

    What is the error you are receiving?
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Go with Attach - Detach database or Backup Restore.
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Please make sure back is full and database type also.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now