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.

Subscribe to Download


Version1.0
Download6
File Size882.69 KB
Create DateSeptember 17, 2016
Last UpdatedSeptember 17, 2016
SQL Server Change Data Capture
Partitioning in SQL Server