Previous Topic: Create a Log Backup to Disk or TapeNext Topic: Truncating Transaction Logs

Database Administration for Specific Platforms › SQL Server/Windows Routine Procedures › Adjusting Database Size

Adjusting Database Size

As you increase the number of models in your encyclopedia, you may need to increase the size of the Encyclopedia database.

The simplest way to increase the size of a database is to expand it using the Microsoft SQL Management Studio.

Note: The default installation procedure creates a device size equal to your database size. After the installation, you may need to add a device and expand your database onto that device.

Follow these steps:

  1. Start the Microsoft SQL Management Studio icon from the SQL Server folder.
  2. Highlight the database to which you want to add space. You may need to select plus(+) boxes to expand the Server Manager listing to show your database.
  3. Select database properties.
  4. If it is not already selected, select the General tab.
  5. In the file properties section, verify that Automatically grow file is checked. Enter values for File Growth and Maximum file size.
  6. Click OK.

If the transaction log for your database fills up, use this same procedure to add space to the log device, using the Transaction Log tab.