<div>
When you navigate to the bak file to restore from (and click ok) you should see 2 sides to the next window.<br />
The logical file name and the file path.<br />
As Mike says the path shown will be then one relevant to the server where the bak file originated from.<br />
Click on this (right hand side) and change the path to suit.
</div>


When you navigate to the bak file to restore from (and click ok) you should see 2 sides to the next window.
The logical file name and the file path.
As Mike says the path shown will be then one relevant to the server where the bak file originated from.
Click on this (right hand side) and change the path to suit.

<div>
<div class="content wysiwyg-content">
I have a Backup of a Database. I want to restore it on other Sql Server. Installation Paths are all different. Problem arrises when I restore this Databse. Error shows that<br />
<br />
Device Activation Error The Physical File Name D:\-----\mydb.mdf may be incorrect.<br />
same Error with .ldf file<br />
<br />
I read Microsoft article . IT told me that First Detach all Databases from Destination server like master, Pubs etc etc and then first Restore all these Databases and then restore your Own mydb Database.<br />
<br />
Tell me the exact Procedure of restoring or attaching a Database whenever I have only .BAK File.
</div>
</div>


I have a Backup of a Database. I want to restore it on other Sql Server. Installation Paths are all different. Problem arrises when I restore this Databse. Error shows that

Device Activation Error The Physical File Name D:\-----\mydb.mdf may be incorrect.
same Error with .ldf file

I read Microsoft article . IT told me that First Detach all Databases from Destination server like master, Pubs etc etc and then first Restore all these Databases and then restore your Own mydb Database.

Tell me the exact Procedure of restoring or attaching a Database whenever I have only .BAK File.

Database Restoration Problem

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.