peaeater
/ restore.ps1
Created
December 15, 2016 19:06
Powershell script to restore a SQL database from a backup file, with progress indicator.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <# | |
| sqlps dependency | |
| If module sqlps does not exist, install from: | |
| Microsoft SQL Server 2016 Feature Pack (https://www.microsoft.com/en-us/download/details.aspx?id=52676) | |
| - SQLSysClrTypes.msi | |
| - SharedManagementObjects.msi | |
| - PowershellTools.msi | |
| #> | |
| param( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <# | |
| Powershell Module 7-Zip - 7-Zip commands for PowerShell | |
| The functions in this module call 7za.exe, the standAlone version of 7-zip to perform various tasks on 7-zip archives. | |
| Place anywhere, together with 7za.exe and 7zsd.sfx. 7za.exe is required for all operations; 7zsd.sfx for creating self | |
| extracting archives. | |
| http://www.7-zip.org | |
| Import-Module [Your path\]7-Zip |