Post reply

What are the mandatory system dbs to start the sqlserver ?

  • March 16, 2012 at 12:26 pm

    #254976

    What are the mandatory system dbs to start the sqlserver service?

    Master,model,tempdb and msdb all these are mandatory ?

  • March 16, 2012 at 12:31 pm

    #1460690

    Don't forget the hidden resource database.

    I am curious why you are asking?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 16, 2012 at 12:39 pm

    #1460699

    actual my doubt is

    can we able to start sqlserver without msdb ?

  • March 16, 2012 at 12:43 pm

    #1460700

    Yes you can. But you should have a backup of that database available so you can bring it back online. Sounds like you are in the middle of trying to recover from losing some system databases. Is that about right?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 16, 2012 at 12:46 pm

    #1460703

    yes.. i have only master files..

    my plan is to first start the sqlserver using with master db and later will restore the other system dbs.

  • March 16, 2012 at 12:47 pm

    #1460704

    here is the steps

    http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/06/619304.aspx

  • March 16, 2012 at 12:53 pm

    #1460708

    thanks and how can i create model ,tempdb and resource dbs ?

  • March 16, 2012 at 1:01 pm

    #1460713

    tempdb is automatically recreated.

    Model, you can restore from backup. Alternatively you can copy the mdf and ldf into the appropriate directory

    Resource, you need to make sure you have those files available from backup.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 16, 2012 at 1:12 pm

    #1460724

    thanks....now everything is clear...

  • March 16, 2012 at 1:46 pm

    #1460745

    Agree with everything that has been said.......gives a whole new meaning to "You are only as good as your "last" backup" 😀

  • March 16, 2012 at 2:16 pm

    #1460762

    CYates (3/16/2012)

    Agree with everything that has been said.......gives a whole new meaning to "You are only as good as your "last" backup" 😀

    Backups are worthless,

    Restores are priceless.

Viewing 11 posts - 1 through 10 (of 10 total)

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