How many types of system database:-
SYSTEM DATABASES: Once we install SQL Server, a set of FIVE system databases are AUTO created.
A. MASTER : Used to control connections and Client-Server TDS Packets including Other databases in the instance (server).
B. MODEL : Used to define a template for new databases we create on the server. We can create upto 32767 databases in an instance.
C. MSDB : Used to manage the server & databases. This database is used by DBAs & MSBI Deployment Managers for routine maintenance activities.
Ex: SQL Server Jobs, Alerts, Emails, SSIS Packages....
Ex: SQL Server Jobs, Alerts, Emails, SSIS Packages....
D. TEMPDB : Used to perform calculations, indexes, query tuning (making the queries run faster), temporary storage. TEMPORARY TABLES
E. RESOURCE DATABASE : Read Only, hidden databases used to control all above system databases. This is started by SQL Server "Service".
No comments:
Post a Comment