<div>
the error reads 'the backup set holds a backup of a database other than the existing 'dbase name' database.<br />
<br />
If I delete the empty database of the same name it throws multiple errors.
</div>


the error reads 'the backup set holds a backup of a database other than the existing 'dbase name' database.

If I delete the empty database of the same name it throws multiple errors.

<div>
worked as a text query, but not using the wizard.
</div>


worked as a text query, but not using the wizard.

<div>
<div class="content wysiwyg-content">
I used to do this a lot and for some reason it is not working this time.<br />
<br />
I have sql server 2012 and I am trying to migrate a database to another machine not on my network. &nbsp;In previous version, I would have simply backed up the database and restored it on the new instance of sql. &nbsp;This does not seem to be working. &nbsp;What is the easiest way to complete this transaction?<br />
<br />
Thanks,
</div>
</div>


I used to do this a lot and for some reason it is not working this time.

I have sql server 2012 and I am trying to migrate a database to another machine not on my network.  In previous version, I would have simply backed up the database and restored it on the new instance of sql.  This does not seem to be working.  What is the easiest way to complete this transaction?

Thanks,

use .bak to move database to another server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.