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
There are no reviews yet.