Discussion Board

System Databases When SQL server is installed, it includes the following system databases: 1. Resource Database: It is a read-only database that contains system objects that are included with SQL Server. System objects are physically persisted in the Resource database, but they logically appear in the sys schema of every database. 2. Model Database: It is used as the template for all databases created on the instance of SQL Server. Modifications made to the model database, such as database size, collation, recovery model, and other database options, are applied to any databases created afterward. 3. Master Database: It records all the system-level information for an instance of SQL Server. 4. tempdb Database: It is a workspace for holding temporary objects or intermediate result sets. 5. msdb Database: It is used by SQL Server Agent for scheduling alerts and jobs. Master and Model databases are created by default. Prajakta Pandit 03-10-2017 12:57 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*