Home / Commands / Invoke-sqmRestoreDatabase
Invoke-sqmRestoreDatabase
Backup sqmSQLTool v1.8.2+
Restores a database from a backup file, with support for single-server and AlwaysOn environments.

Examples

# Simple restore of a full backup file
# Simple restore of a full backup file
Invoke-sqmRestoreDatabase -SqlInstance "SQL01" -BackupFile "D:\Backup\AdventureWorks.bak" -DatabaseName "AdventureWorks"
# Restore with Full + Diff + Logs
# Restore with Full + Diff + Logs
$backupSequence = @(
    "D:\Backup\AdventureWorks_Full.bak",
    "D:\Backup\AdventureWorks_Diff.bak",
    "D:\Backup\AdventureWorks_Log1.trn",
    "D:\Backup\AdventureWorks_Log2.trn"
)
Invoke-sqmRestoreDatabase -SqlInstance "SQL01" -BackupFiles $backupSequence -DatabaseName "AdventureWorks"
# Restore with new name and forced Single-User mode
# Restore with new name and forced Single-User mode
Invoke-sqmRestoreDatabase -SqlInstance "SQL01" -BackupFile "D:\Backup\OldDB.bak" -DatabaseName "OldDB" -NewDatabaseName "NewDB" -ForceSingleUser
← Previous Command
Invoke-sqmLogShrink
Next Command →
Invoke-sqmUserDatabaseBackup