Restore SQL Databases

restoreDatabases_Orig.ps1

$restoreDir = "J:\Backups"
# Get files in backup directory
$files = get-childitem $restoreDir -recurse
foreach ($file in $files)
  {
     $query = "RESTORE DATABASE [" + $file.basename + "] 
               FROM DISK = N'" + $restoreDir + $file + "' WITH  FILE = 1, 
               MOVE N'" + $file.basename + "' TO N'" + $dataLocation + $file.basename + ".mdf', 
               MOVE N'" + $file.basename + "_log' TO N'" + $logLocation + $file.basename + "_log.LDF', 
               NOUNLOAD,  
               STATS = 5"  

     invoke-sqlcmd -query $query -Database "Master" -ServerInstance $serverInstance -Username "SA" -Password "Password1"
     write-host ("$query")
  }