Skip to content

Instantly share code, notes, and snippets.

@pallid
pallid / GerenateRestoreCommand.ps1
Created October 23, 2015 06:19
Generate restore command for each backup file in $backupFolder
#Generate restore command for each backup file in $backupFolder
#Author: Evgeny Khabarov <ekhabarov@dev.ms>
#Date: 08.06.2015
#Import module for use SMO objects
Import-Module "SQLPS" -DisableNameChecking;
$sqlserver = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server('.');
$restore = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Restore;