Difference between revisions of "MSSQL Database stuck in restore state"
From DevOps Notebook
(Created page with "<syntaxhighlight lang="sql"> USE [master] RESTORE DATABASE [SportifierDB_Restore] FROM DISK = N'D:\BackupFromPRD\AutoRestore\AutoRestoreSpotifierDBFresh.bak' WITH RECOVERY...") |
|||
| Line 2: | Line 2: | ||
USE [master] | USE [master] | ||
| − | RESTORE DATABASE [ | + | RESTORE DATABASE [Database.Name] |
| − | FROM DISK = N' | + | FROM DISK = N'C:\PathToBackupFiles.bak' WITH RECOVERY |
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 11:14, 6 July 2021
USE [master]
RESTORE DATABASE [Database.Name]
FROM DISK = N'C:\PathToBackupFiles.bak' WITH RECOVERY
