After a long time, I did open SQL Server Management Studio and connected to a database. Just remembered the basis which I read when I didn't my career.
Master
This database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer this database with care.
Msdb
This database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.
Model
This database is essentially a template database used in the creation of any new user database created in the instance.
Tempdb
The tempdb holds temporary objects such as global and local temporary tables and stored procedures.
Hope this helps.
--
Cheers,
Gopinath
Master
This database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer this database with care.
Msdb
This database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.
Model
This database is essentially a template database used in the creation of any new user database created in the instance.
Tempdb
The tempdb holds temporary objects such as global and local temporary tables and stored procedures.
Hope this helps.
--
Cheers,
Gopinath
No comments:
Post a Comment