<div>
I want to copy the files not move them. Can you explain further?
</div>


I want to copy the files not move them. Can you explain further?

<div>
WITH MOVE just means you are chaing the location of the files in the database being restored to. &nbsp;You are &quot;moving&quot; the files to a different location than the catalog had them.<br />

</div>


WITH MOVE just means you are chaing the location of the files in the database being restored to.  You are "moving" the files to a different location than the catalog had them.


<div>
<div class="content wysiwyg-content">
I need to copy my existing database called Tribase to a new one called Tribase2 in SQL 2005 Express. I created a new Database Called Tribase2 and made a backup of Tribase then used the following to restore to Tribase2: restore database Tribase2 &nbsp;from disk = 'C:\Inetpub\ftproot\Backup<wbr />s\SQLBacku<wbr />ps\Tribase<wbr />BU.bak' &nbsp; But get the following error: &nbsp;&quot;The backup set holds a backup of a database other than the existing 'Tribase2' database.&quot; &nbsp; I am not an expert so Im probably missing something. How can I effectively make this work.
</div>
</div>


I need to copy my existing database called Tribase to a new one called Tribase2 in SQL 2005 Express. I created a new Database Called Tribase2 and made a backup of Tribase then used the following to restore to Tribase2: restore database Tribase2  from disk = 'C:\Inetpub\ftproot\Backups\SQLBackups\TribaseBU.bak'   But get the following error:  "The backup set holds a backup of a database other than the existing 'Tribase2' database."   I am not an expert so Im probably missing something. How can I effectively make this work.

Copy Database to Other New 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.