How can I increase the size of the database used for Web Reporter?
book
Article ID: 53906
calendar_today
Updated On:
Products
STORAGE RESOURCE MANAGEMENT SUITE
Issue/Introduction
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.
Environment
BRMAPS20100-11.7-Storage Resource Manager-Application Server
Resolution
To increase the size of a database
Connect to an instance of the SQL Server Database Engine in the SQL Server Management Studio Object Explorer.
Expand the instance.
Expand Databases and select the database that you want to increase the size.
Right-click the database to increase, and click Properties.
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