Post reply

Message "Starting up database " everyday in SQL Server log

  • November 23, 2009 at 2:52 am

    #135415

    Hello all,

    i am see this Message "Starting up database " everyday in SQL Server log.

    Please tell me what could the reason behind this..

    Generally as per my know if database is restored or brought online this message is seen.

    SQL Server 2005 sp3 installed on my server

    Regards

    Ramu

  • November 23, 2009 at 2:55 am

    #1082850

    Select the database, right click properties--> Options-->Set Auto Close to False.

  • November 23, 2009 at 3:46 am

    #1082868

    thanks.. i will monitor the logs.

  • November 24, 2009 at 10:40 pm

    #1083811

    Here is the simple alter statement you can use, just change the name of the database.

    ALTER DATABASE MYDATABASE SET AUTO_CLOSE OFF

  • November 24, 2009 at 10:47 pm

    #1083812

    Here is the simple statement you can use to turn of Auto close option, just change the database name.

    ALTER DATABASE MYDATABASE SET AUTO_CLOSE OFF

  • November 25, 2009 at 9:34 am

    #1084165

    thanks it worked.

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

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