How can I increase the size of the database used for Web Reporter?

Document ID : KB000053906
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

You can increase the size of a database by using Object Explorer in SQL Server Management Studio. The database is expanded by either increasing the size of an existing data or log file or by adding a new file to the database.

Solution

To increase the size of a database

  1. Connect to an instance of the SQL Server Database Engine in the SQL Server Management Studio Object Explorer.

  2. Expand the instance.

  3. Expand Databases and select the database that you want to increase the size.

  4. Right-click the database to increase, and click Properties.

  5. Select the Files page in Database Properties.


    To increase the size of an existing file

    • Increase the value in the Initial Size (MB) column for the file.


      Make the data file as large as possible, based on the maximum amount of data you expect in the database.


      To increase the size of the database by adding a new file

      1. Click Add

    Type the values for the new file.

  6. Click OK.