Difference between revisions of "MSSQL Database stuck in restore state"
From DevOps Notebook
| Line 2: | Line 2: | ||
USE [master] | USE [master] | ||
| − | RESTORE DATABASE [ | + | RESTORE DATABASE [YourDatabase.Name] |
FROM DISK = N'C:\PathToBackupFiles.bak' WITH RECOVERY | FROM DISK = N'C:\PathToBackupFiles.bak' WITH RECOVERY | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 11:14, 6 July 2021
USE [master]
RESTORE DATABASE [YourDatabase.Name]
FROM DISK = N'C:\PathToBackupFiles.bak' WITH RECOVERY
