How do I disable automatic file growth? (NETIQKB11540)

  • 7711540
  • 02-Feb-2007
  • 08-Sep-2008

Resolution

goal
How do I disable automatic file growth?

fact
Security Manager 4.X

fact
Security Manager 3.X

fact
Operations Manager 3.x

fact
Security Manager 5.X

fix

To disable autogrow:

  1. Open 'Enterprise Manager'.
  2. Expand 'MS SQL ServersExpand SQL Server Group'.
     
  3. Expand the database server in question.
  4. Expand the 'databases' folder.
  5. Right-click DatabaseName database and select Properties
  6. Select the 'Data Files' tab and deselect the Automatically grow file checkbox. 
  7. Click OK


Additional Information

Formerly known as NETIQKB11540