SQL 2008 R2:  Copy a Database

Posted on 2012-09-10
Medium Priority
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

LIONKING earned 1000 total points
ID: 38383754
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 --> http://msdn.microsoft.com/en-us/library/ms188664.aspx

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

Jared_S earned 1000 total points
ID: 38383800
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

ID: 38405846
Thank you.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
Suggested Courses

850 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