Post reply

Set maximum log file size

  • July 14, 2006 at 7:26 am

    #61290

    Is there a script to set the maximum a log file will grow to, using TSQL, not Enterprise Manager?

    Thanks...Nali

  • July 14, 2006 at 8:00 am

    #649255

    From BOL

    ALTER DATABASE Test1

    MODIFY FILE

       (NAME = Test_log,

       SIZE = 20MB,

    MaxSize=80MB 

    &nbsp

    GO

     

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

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