<div>
Thanks. Got it.<br />
<br />
newbieweb
</div>


<div>
<div class="content wysiwyg-content">
I use MS SQL Server Management Studio and SQL Express 2005. &nbsp;I have live database I can not seem to get to stop or take offline. &nbsp;But I need to copy it.<br />
<br />
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. &nbsp;Since there is no database to restore to, it fails.<br />
<br />
Can someone suggest how I can get the exact database onto a second machine??<br />
<br />
thanks,<br />
newbieweb
</div>
</div>


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??

thanks,
newbieweb

Need a copy of a live SQLExpress database

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.