but why not....you'll have to identify the new physical location in the restore..
RESTORE DATABASE TaxReconDB_Prod
FROM DISK = 'D:\Tax\BackUp\TaxReconDB.dmp'
WITH MOVE 'TaxReconDB_Data' TO 'D:\Database\NJROS1D151DEV\MSSQL$NJROS1D151DEV\Data\TaxReconDB_Prod_Data.MDF'
, MOVE 'TaxReconDB_Log' TO 'D:\Database\NJROS1D151DEV\MSSQL$NJROS1D151DEV\Data\TaxReconDB_Prod_Log.LDF'
It is a common trick for upgrading server hardware. You run up the new box (offline) with the same name and IP as the old box. You then restore master and reattach the other databases, and life is good!
Originally posted by sqlserver2k
As far as the locations and the drive specification are same, you are safe. But if the system databases where on a different drive on the old server than the new one, then you are in trouble.
Why is that? We move from C: to E: (and back) all of the time.