mssqltips logo

SQL Server Master Database Tutorial Outline



By:
Overview

In this tutorial we will cover common questions related to the SQL Server master database. This is one of the standard system databases that are part of every SQL Server installation. This tutorial will give you a better idea of what the master database is used for, how to configure and maintain it and how to know what data and objects are stored in the master database.

The following sections will be covered in the tutorial:

  • SQL Server Master Database Overview
  • SQL Server Master Database Location
  • SQL Server Master Database Size and Growth
  • SQL Server Master Database Maintenance
  • SQL Server Master Database Tables
  • SQL Server Master Database Objects
  • SQL Server Master Database Permissions
  • SQL Server Master Database Backup
  • SQL Server Master Database Recovery Model
  • SQL Server Master Database Restore
  • SQL Server Master Database Disaster Recovery Plan

Let's get started.


Last Update: 10/8/2019




More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download





get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools