SQL 2008 R2: Copy a Database

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.
itsmevicAsked:
Who is Participating?
 
Jared_SCommented:
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.
0
 
LIONKINGCommented:
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.
0
 
itsmevicAuthor Commented:
Thank you.
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.

All Courses

From novice to tech pro — start learning today.