How to Restore MSDB Database - SQL Server DBA Tutorial

In this video you will learn how to restore SQL Server System database msdb from its back using SQL Server Management studio as well as using T-SQL Script. It takes the scenario of having to restore msdb from its backup when it was recently built with recent and restorable backup file.

Script used in Video to Restore MSDB Database in SQL Server

USE [master] 

ALTER DATABASE [msdb] 

SET single_user WITH 

ROLLBACK immediate 

RESTORE DATABASE [msdb] FROM DISK = N'C:\SQLSysBackup\msdb.bak' WITH FILE = 1, 
nounload, replace, stats = 5 

ALTER DATABASE [msdb] 

SET multi_user 

go

 

How to Restore MSDB Database - SQL Server DBA Tutorial