System Databases
The system databases exist to support the operation of SQL Server. The four system databases—master, model, msdb, and tempdb—are created by the installation program. The system databases are said to contain “metadata,” or data about data. These databases cannot be dropped.
master
As the name implies, the master database is the repository for all system-wide information for SQL Server. If an object is defined at the server level, it is stored in master. Login accounts, configuration settings, system-stored procedures, and the existence of other databases are recorded in the master database. SQL Server will not run if the master database is damaged or corrupt; therefore, it is imperative that the master database is backed up on ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
