![]() The system database stores information regarding logins, configuration settings, connected servers etc. Describe in brief system database.The system database contains information/metadata for all database present on an SQL Server instance. The Resource database does not contain user data or user metadata. 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 resoure Database is a read-only database that contains all the system objects that are included with SQL Server. The model is essentially a template database used in the creation of any new user database created in the instance. The tempdb is used to store temporary objects such as global and local temporary tables and stored procedures. The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping. The server cannot start if the database is not configured properly. What are the basic functions for master, msdb, model, tempdb and resource databases?Master database is used to store information of all the databases on the SQL server. It is a template database used in the creation of new database. It stores temporary objects like temporary tables and temporary stored procedure. It stores information related to database backups, DTS packages, Replication, SQL Agent information, SQL Server jobs. Without Master database, server can't be started. It is a very important database and important to backup Master database. It contains information about server’s configuration.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |