Expanding Your Database

If your database needs to expand beyond the initial limits you specified for either the data file or the transaction log file, you can manually expand the database using SQL Server Enterprise Manager.

Warning

• Do not use the automatic file growth option of SQL Server. Using this option may adversely affect the performance of your Microsoft Operations Manager 2000 implementation.

To expand your database:

1. Log on with an Administrator account to the computer on which you installed the database.
2. Run Enterprise Manager from the Microsoft SQL Server folder.
3. Expand SQL Server Group.
4. Expand the server that contains the database.
5. Expand Databases.
6. Click OnePoint.
7. Click Action on the menu bar.
8. Click Properties on the Action menu.
9. Select the General tab on the Microsoft Operations Manager 2000 Properties window.
10. Click the number in the Space Allocated column of the Database Files text box.

11. This number is the size of the database data file in megabytes.

12. Type the new size of the database data file.
13. Select the Transaction Log tab on the Microsoft Operations Manager 2000 Properties window.
14. Click the number in the Space Allocated column of the Transaction Log Files text box.

15. This number is the size of the database transaction log file in megabytes.

16. Type the new size of the database transaction log file, and then click OK.
17. Close the SQL Server Enterprise Manager.