The use and impact of the default databases which comes with the SQL Server, when its installed.
Master: The master database is composed of system tables that keep track of the server installation as a whole and all other databases that are subsequently created. the master database has system catalogs that keep information about disk space, file allocations, usage, system wide configuration settings, login accounts, the existence of other databases, and the existence of other SQL servers (for distributed operations).
Model: The model database is simply a template database. Every time you create a new database, SQL Server makes a copy of model to form the basis of the new database. If you'd like every new database to start out with certain objects or permissions, you can put them in model, and all new databases will inherit them.
TempDB: The temporary database, tempdb, is a workspace. SQL Server's tempdb database is unique among all other databases because it's re-created—not recovered—every time SQL Server is restarted. It's used for temporary tables explicitly created by users, for worktables to hold intermediate results created internally by SQL Server during query processing and sorting, and for the materialization of static cursors and the keys of keyset cursors. Operations within tempdb are logged so that transactions on temporary tables can be rolled back, but the records in the log contain only enough information to roll back a transaction, not to recover (or redo) it.
All users have the privileges to create and use private and global temporary tables that reside in tempdb. (Private and global table names have # and ## prefixes).
Pubs: The pubs database is a sample database used extensively by much of the SQL Server documentation.
You shouldn't worry about making modifications in the pubs database as you experiment with SQL Server features. You can completely rebuild the pubs database from scratch by running a script in the \Install subdirectory (located right under the SQL Server installation directory). In SQL Query Analyzer, open the file named Instpubs.sql and execute it. You do need to make sure that there are no current connections to pubs, because the current pubs database is dropped before the new one is created.
Northwind: The Northwind database is a sample database that was originally developed for use with Microsoft Access. Much of the documentation dealing with APIs uses Northwind, as do some of the newer examples in the SQL Server documentation.
The Northwind database can be rebuilt just like the pubs database, by running a script located in the Install subdirectory. The file is called Instnwnd.sql.
MSDB: The msdb database is used by the SQL Server Agent service, which performs scheduled activities such as backups and replication tasks. In general, other than performing backups and maintenance on this database, you should ignore msdb.
|
No responses found. Be the first to respond and make money from revenue sharing program.
|