With SQL Server 2008, you can manage database and log size either automatically or manually. You can use SQL Server Management Studio or Transact-SQL to configure database or log size.
Using SQL Server Management Studio, you can configure automatic management of database and log size by performing the following steps:
Select Files from the Select A Page list in the Database Properties dialog box. Each data and log file associated with the database is listed under Database Files. For each data and log file, do the following:
- Click the button to the right of the file’s Autogrowth box to adjust the related settings. This will display the Change Autogrowth For dialog box.
- Set the file to grow using a percentage or an amount in megabytes, and then either restrict the maximum file growth to a specific size or allow unrestricted file growth.
- Click OK.