Note
It is important to remember that SQL Server actually uses its own set of databases that are installed by default when SQL Server is installed. These databases are referred to as system databases. The databases that users create are aptly named user databases. The system databases include master, model, msdb, tempdb, and resource. Each of these databases performs a key function in the operation of SQL Server. For example, the master database contains an entry for every user database created and contains server-wide information critical to the operation of SQL Server. The model database is basically a template database for any newly created databases. Each system database is based on a structure similar to user databases and contain database ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
