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??