What is the master db in SQL SERVER for?


The master database is one of the default databases installed in your SQL Server.  If it were to become corrupted, your SQL server may no longer work correctly.

  1. Logins and roles associated with user ids.
  2. System configuration settings such as data sorting info, security implementation and default language
  3. The names of and info about the databases on the server
  4. The location of each database
  5. System tables that tell you:  available languages and characters, system errors and warning messages the way the cache is used and several other things.

Backing up this table should be a part of your routine back up.

Leave a comment

Filed under Sharing Stuff

Comment on this