copy database in sql server express 2008

What is the best way to copy a database from one instance of sql server express 2008 to another?

Thanks~
Bob SchneiderCo-OwnerAsked:
Who is Participating?
 
AirShieldCommented:
Backup the database and restoring it in the other instance works wonderfully!
0
 
Éric MoreauSenior .Net ConsultantCommented:
or detach, copy, attach
0
 
Bob SchneiderCo-OwnerAuthor Commented:
I like the back-up idea but I tried it and I can't get my sql server to back it up in a place where my local drive can find it.  I tried backing it up to dropbox.com but I am using a third-party back-up utility to schedule back-ups and it won't allow that.  Isn't there any third-party utility that will help me find the db and copy to my local drive?  I really don't want a multi-step process.  I can access it through my sql server enterprise manager but I can't copy because of the express designation.
0
 
AirShieldCommented:
BobbaBuoy:
I like the back-up idea but I tried it and I can't get my sql server to back it up in a place where my local drive can find it

What do you mean exactly?? did you get any errors when trying to backup to an specific folder?
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.