Post reply

Model Database

  • February 9, 2011 at 11:56 pm

    #233382

    Dear All,

    Can someone help me out? please

    1)I can see free space is 0%(Space used 100%) for .mdf file of Model database.

    2) How to check who and when restarted the SQLServer Services?

    Please advise.

    Thanks and Regards,

    Ravi.

  • February 10, 2011 at 12:10 am

    #1284966

    1 Why not set the auto-growth feature as ON for the database.

    2 Regarding SQL Server Restart, the information can be found in the SQL Server Logs or you can check the creation time of tempdb database. tempdb gets created each time when SQL Server restarts.

    Cheers,

    Satnam

  • February 10, 2011 at 1:54 am

    #1284997

    Thanks Satnam Singh for the reply !!

    Auto growth is set to ON for Model Database.

    I can see in ERROR Log as "2011-02-09 03:06:30.86 spid5s SQL Trace ID 1 was started by login "sa", this means were services restared by sa ?

    Please advice.

    Regards,

    Ravi.

  • February 10, 2011 at 7:45 am

    #1285199

    in model, properties, files.

    increase the file initial size and also put hte autogrowth to 1% or 10 mb autogrowth unrestricted.

    Regarding sql services , see the error logs

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • February 15, 2011 at 4:29 am

    #1286959

    Thanks Sushant !!

    It's worked.

    Thanks and Regards,

    Ravi.

Viewing 5 posts - 1 through 4 (of 4 total)

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