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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s