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] 


SET single_user WITH 

ROLLBACK immediate 

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


SET multi_user 


How to Restore MSDB Database - SQL Server DBA Tutorial


  1. ks for sharing the article, and more importantly, your personal experienceMindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story, since I can certainly relate and I think others can too