Home Forums SQL Server 2008 SQL Server 2008 Administration database log file RE: database log file

  • December 5, 2012 at 3:21 am

    #1565644

    sqlfriends (12/4/2012)

    If a database is setup to readonly.

    Will the log file grow or not?

    thanks

    NO

    sqlfriends (12/4/2012)

    If a database is setup in simple recovery mode.

    Will the log file grow or not?

    thanks

    Yes

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)