Setting Initial Database File Sizes

This topic describes how to set initial MDF and LDF file size for the ObserveIT databases on the SQL Server. Setting the initial size for the database files and database log files assures that the database writing is optimized.

  1. Connect to the SQL server or to a computer with SQL Server Management Studio installed.

  2. Open Microsoft SQL Server Management Studio.

  3. The Connect to server window opens.

  4. Type in the SQL server's FQDN or IP address into the Server name field.

  5. Select Windows Authentication if your account has sysadmin permissions on the SQL server. Otherwise, choose SQL Server Authentication and log in with a sysadmin-level account.

  6. Click OK.

  7. Expand Databases to connect.

  8. Right-click the ObserveIT database and select Properties.

  9. Click Files from Select a Page menu.

  10. Change the Initial Size (MB) value for the ObserveIT_Data logical name to 102400MB.

  11. Change the Initial Size (MB) value for the ObserveIT_Log logical name to 51200MB.

  12. Click OK.

Related Topics:

Installing and Configuring Databases

Installing the ObserveIT Databases

Verifying Database Installation

Moving Database File to Drives

Installing Database Maintenance

** Go to Custom Installation Steps.