Master databse role in SQL

Posted on 2005-05-15
Last Modified: 2010-03-19
When restoring databases with BackupExec, do I need to restore the master database when restoring other databses, or can it be left alone unless it is obviously corrupted or damaged in some way?

Come to that, how can I tell if the master datase is damaged? Indeed, what is its role in SQL?

I'm a newbie to SQL...
Question by:Duncan Meyers
    LVL 3

    Expert Comment

    there is no need to restore master DB, these Db are given for ur references & making studies on various issues.
    LVL 3

    Expert Comment

    MAster Database contains the setting of the database,
    the language setting tables etc.

    No need to normally restore the master database.
    LVL 68

    Accepted Solution

    >> When restoring databases with BackupExec, do I need to restore the master database when restoring other databases <<

    No (agreeing with others).  In fact, you do *not* want to restore the master db unless you absolutely have to, because that would require restoring and recovering (if possible) the other dbs.

    >> Come to that, how can I tell if the master datase is damaged? <<

    Run this command (in Query Analyzer):  DBCC CHECKDB ('master')

    The next-to-last line of the result should be:
    "CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'."

    If the totals are not "0" and "0", then you have a problem :-) .

    >> Indeed, what is its role in SQL? <<

    It contains all information necessary to control the SQL Server instance, including some info on all of the other databases.  For example, master, but no other db, has:

    1) a list of all dbs on the server with some info about each (sysdatabases)
    2) info on current SQL activity (sysprocesses)
    3) all SQL logins (syslogins)
    4) all server configuration info (sysconfigures; entries include default language, min/max memory, etc. (for more info, in Books Online see topic "sp_configure" and choose the link to "Setting Configuration Options"))
    5) performance info (sysperfinfo)

    and more (for a complete list, see topic "master database", subtopic "information stored in system tables", and look at the first box titled "System Tables in the master Database Only")
    LVL 30

    Author Comment

    by:Duncan Meyers
    Thanks! Very comprehensive answer.

    I'm only involved with SQL for backup testing, hence my abject ignorance. Learning about SQL is on my 'to do' list (1,000,000 miles long and growing...)
    LVL 30

    Author Comment

    by:Duncan Meyers
    Do you want to post to this Q:

    You've answered my second question in this one, so you deserve the points :-)

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now