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

2 comments:

  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
    kodi.software

    ReplyDelete