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.