Hands-On-Lab: Managing System Databases in SQL Server

Hello Friends,

Here is another popular lab from Hands-On-Lab library: Managing System Databases in SQL Server.

System database are moved for different purposes. The major reasons could be performance improvement, disk maintenance, hardware failures, space constraints. Moving the system databases offers some real advantages but needs to be done carefully and consistently. In this lab, it is explained step by step on how to move and rebuild different system databases such as Tempdb, Model, Msdb and Master database. Backups of System databases helps to restore and recover the SQL Server system if any system failure occurs. You cannot back up the Tempdb system database. This lab is divided into five exercises. In the first exercise we will learn to move tempdb to a new location. In the second exercise we will learn to move MSDB and Model databases to a new location. In the third exercise we will learn to move master database to a new location. In the fourth exercise we will learn to take backups of system databases and how to restore them. In the fifth exercise we will learn to rebuild the system databases.

Exercise 1: Move Tempdb to a new location
Exercise 2: Moving MSDB and Model database
Exercise 3: Move master database to a new location
Exercise 4: Backup and restore System Databases
Exercise 5: Rebuilding your System Databases

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.