-
System Databases : Restrictions Matrix
Dear Readers, Today, I tried to consolidate a list of restrictions that are applied to system databases. Restrictions are nothing but the operations that you “can not” perform on a system database. Below is a consolidated matrix (rows are restrictions) and when you see YES in the column, that means restriction is applied. If there is nothing, that…
-
March towards SQL Server : Day 9 – SQL DBA Interview Questions Answers – All about SQL Server System Databases and Recovery Model
This blog is about the interview Questions on the System databases, Important activities with the system databases and Recovery models. 1) What are system databases? When we install Microsoft SQL Server, five system databases are automatically created for each SQL Server instance. These system databases allow the database engine and administrative applications to properly manage the…