Home Forums SQL Server 2014 Administration - SQL Server 2014 What system databases are required to start sql server / where to store? RE: What system databases are required to start sql server / where to store?

  • March 2, 2015 at 11:38 am

    #1781183

    HookSqlDba7 (2/27/2015)

    With SQL Server 2012/2014, what system databases are requried in order for sql sever to start? Of the following system databases:

    master - contains all system-wide information.

    msdb - holds information for SQL Server Agent; jobs, operators, alerts, etc.

    model - template on which all user databases are based.

    tempdb - holds temporary data.

    resource - read-only hidden database that contains system objects that are mapped to the sys schema in every database.

    I have heard the master and model databases are all that is required to start sql server. Is this true?

    All except MSDB (which is required for SQL Agent to start).

    The TempDB files aren't required, but the location which the files should go has to exist)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass