restore all databases

• joujousagem2006 1602

  SSCommitted

  Points: 1779

  More actions

  June 6, 2018 at 4:20 pm

  #351426

  Hello everyone

  I need to restore almost 100 backup put on a folder through a single script

  for that I try to script these 3 lines but the powershell it makes me return errors that can correct me 
  $databases=Get-ChildItem -path C:\folder -Filter *.bak
foreach($database in $databases)
{
Restore-SqlDatabase -ServerInstance .\sqlprod -Database $database -BackupFile $database.fullname
}

  
  thank you

• frederico_fonseca

  SSCoach

  Points: 16017

  More actions

  June 6, 2018 at 5:05 pm

  #1993160

  message is quite clear - access denied 
  the user SQL Server instance is running under needs access to the folder "c:\folder"