Changing the Autogrow Settings 

Use

SQL Server 7.0 offers an autogrow option for files. This allows database files to automatically grow when they are full provided that enough space is still available on the disk. The amount a file can grow is determined by a growth increment that you can specify for each file. When autogrow is enabled, the work involved in monitoring the size of the database is reduced significantly. It no longer necessary to continually monitor the free space in files. It is however important to always keep track of the amount of free space on the disk. There must always be enough space to allow the next required files extension. If the disk with the R/3 database or log files is full, processing in the R/3 System stops. It is therefore essential to know well in advance, when a shortage of disk space will arise.

When R/3 is installed with the SQL Server, the R/3 database is normally created with three data files that each have a size of 2 GB and one log file that has a size of 1.5 GB. If the growth increment for the data files and log files is set to 100 MB, a file automatically grows by 100 MB when it is full.

Procedure

To change the autogrow settings for the different databases in your system, proceed as follows:

  1. In the Enterprise Manager, expand the server and Databases.
  2. Select a database and choose Action ® Properties.

    3. The Database Properties dialog box opens and displays the autogrow settings.

  3. To change the settings for data files switch to the General tab. To change the settings for the log file switch to the Transaction Log tab.
  4. In the File growth section, specify the amount the selected file must grow when it becomes full. You can specify file growth in MB or as a percentage of the total file size.
  5. In the Maximum file size section, select Restrict filegrowth and enter the size the selected file can grow to, or choose Unrestricted file growth.
  6. Confirm your entries with OK.