Need a copy of a live SQLExpress database

I use MS SQL Server Management Studio and SQL Express 2005.  I have live database I can not seem to get to stop or take offline.  But I need to copy it.

I can not detach it, and when I try to back it up, the file is revealed as useless to me when I try and restore it on the target machine.  Since there is no database to restore to, it fails.

Can someone suggest how I can get the exact database onto a second machine??

newbiewebSr. Software EngineerAsked:
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
I would like you to go through the docs:

that should answer your question(s).

now, you cannot "copy" the database files themselves while the database is attached ie online ...
newbiewebSr. Software EngineerAuthor Commented:
Thanks. Got it.

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.