Alter the default collation or owner of the master database.Perform any other type of backup except a FULL backup.Add new files or filegroups to the database.Set the database or primary filegroup to READ_ONLY.Therefore, you are restricted from the following: If the master database is corrupt or missing, the SQL Server cannot start unless repaired.Īs you can guess, SQL Server restricts what you can perform on the master databases. Therefore, it would be a tremendous understatement to state that this is a critical system database. In this database, you will find the information such as: This system database stores all the system-level information for the instance of the server. Let us quickly walk through what they do. System Databases in SQL Serverĭepending on the SQL Server version and installation method, SQL Server provides us with five main system databases. We will also discuss the dos and don’t when it comes to the SQL Server system DBs. In this article, we will level up our SQL Server knowledge by understanding the system databases provided by the SQL Server, and what exactly their purpose is.
Welcome, my fellow database developers, to another SQL Server tutorial.
0 kommentar(er)
