At Luke's powershell script , at bottom lines of the code as below, if I want the source server and destination server has different data file physical path how can we rewrite below codes? For example the source server physical path is E:\MSSQL\Data\
The destination is E:\MSSQL12\Data

# Loop through backup file and configure data and log file names.

$logicalFilename = $null;

$physicalFilename = $null;

foreach ($dbFile IN $backupFiles.Rows){

$logicalFilename = $dbFile.LogicalName;

$physicalFilename = $dbFile.PhysicalName.Replace($sourceInstance, $destInstance).Replace($dbName, $newDbName);

$smoMoveFile = New-Object('Microsoft.SqlServer.Management.Smo.RelocateFile');

$smoMoveFile.LogicalFileName = $logicalFilename;

$smoMoveFile.PhysicalFileName = $physicalFilename;

$smoNewDB.RelocateFiles.Add($smoMoveFile);

}

#Restore db

$smoNewDB.SqlRestore($destServerConnection);