Post reply

Turn off Autofile growth

  • April 17, 2006 at 8:59 am

    #112760

    How to turn off auto file growth , not by enterprise manager?

  • April 17, 2006 at 9:28 am

    #632785

    Look at ALTER DATABASE in BOL.

  • April 17, 2006 at 10:05 am

    #632792

    Default is turn on,  but I counldn't set to off.

  • April 18, 2006 at 11:36 am

    #632924

    You can only turn off this option by file. First you need to execute sp_helpdb for the database in questino to get the logical file names for the mdf and ldf files in the database. Then use the followuing SQL:

     alter database [database name] modify file

      (name = [mdf logical filename], filegrowth = 0MB)

     alter database [database name] modify file

      (name = [ldf logical_ ilename], filegrowth = 0MB)

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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