Post reply

wht is the use of system database

  • January 19, 2005 at 3:21 am

    #74845

    wht is the purpose of master, model, tempdb, and msdb

    in the sql server, wht is this system database used for

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • January 19, 2005 at 4:24 am

    #538013

    master, model, msdb, tempdb are the system database. These are the databases that are critical to SQL Server and that will prevent it from running should they be missing.

    Master handles pretty much everything from security to database locations and their filenames, as well as objects that are used to create things like replication, log shipping etc.

    MSDB handles all of the jobs and dts packages, imports and exports use the objects held within.

    Model contains all the information that SQL needs to create a new database, including sizes, file locations etc.

    TempDB is recreated every time you restart SQL, this contains temporary objects, for example temp tables, hash tables and is used in index creation.

     

    That's just the basics.


    Shamless self promotion - read my blog http://sirsql.net

  • January 19, 2005 at 4:27 am

    #538014

    great,

    thank u for ur information, it was short and sweet

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply