SQL 2008 R2:  Copy a Database

Posted on 2012-09-10
Last Modified: 2012-09-17
Hello Experts,

   I have a fully functional db that i'd like to make a copy of of it.  What's the best way of doing this without detaching the db and jeopordizing stability?   Thanks for your help.  I simply want to copy the database to a flash drive.  Thanks.
Question by:itsmevic
    LVL 13

    Assisted Solution

    You could maybe do a Copy Database without detaching (using the SQL Management Object Method), once your new database is up you can detach and copy in your flash drive.

    Link -->

    Another option is to create a backup, and then restore in the new location.
    Backup Link
    Restore Link

    Hope it helps.
    LVL 12

    Accepted Solution

    Do a full database backup straight to your drive, or back it up and then move the files.

    It's the the easiest way hands-down in my opinion.

    Author Closing Comment

    Thank you.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
    This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

    728 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