What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
- 1 Answers
- 1087 Views
- I also Faced
- E-Mail Answers
Answer Posted / Saurabh Sonkar
"The basic functions of the SQL Server databases are as follows:nn- master: It is a system database that maintains metadata, security, and system configuration information about all databases on an instance of SQL Server.n- msdb: This is another system database that stores data related to SQL Server Agent jobs, alerts, history, and other system-related data.n- model: It is a user-defined template for new databases. Any changes made to the model database will be applied to any new databases created unless specifically overridden.n- tempdb: This is a temporary database that is used to store intermediate results, sorting data, and work tables during query execution. All objects in tempdb are dropped each time the SQL Server instance is restarted.n- resource: These are system databases that can be created by third-party applications. They are used to store application metadata and resources."
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to rebuild the master database?
When should you use an instead of trigger?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Can we shrink data file in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to enter binary string literals in ms sql server?
What is a coalesce function?
How can you append an identity column to a temporary table?
How to provide default values to function parameters?
How to convert character strings into numeric values?
What are the source of constraints?
what is spatial nonclustered index
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Why should you use or avoid select * statements?
What is a scheduled job or what is a scheduled task?
