There are mainly four system database:
1.Msdb
2.Master.
3.Model.
4.Tempdb
Let us see one by one.
Resourse Database
The resoure Database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not contain user data or user metadata.
1.Msdb
2.Master.
3.Model.
4.Tempdb
Let us see one by one.
Master DatabaseMaster database is system database. It contains information about server’s configuration. It is a very important database and important to backup Master database. Without Master database, server can't be started.MSDB DatabaseIt stores information related to database backups, DTS packages, Replication, SQL Agent information, SQL Server jobs. |
TEMPDB Database
It stores temporary objects like temporary tables and temporary stored procedure.
Model Database
It is a template database used in the creation of new database.
Resourse Database
The resoure Database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not contain user data or user metadata.
No comments:
Post a Comment