Extending the MSSQL database

This procedure describes how to extend the MSSQL database, which enables you to extend the size of the data or log files in the database.

To extend the MSSQL database

1. From the Components Tree pane, under the Control-M/EM component, right-click Database: <schema name@database host:database port> and select Extend Database.
2. Log in to the Control-M/EM database as an administrator with your username and password.

   The Control-M/EM Extend Database window appears.

3. Select one of the following database file types that you want to extend:
   • Data
   • Log
4. In the Size field, type the extension size in MB.
5. Do one of the following:
   • In the Current Files area, select the required file.
   • In the New File area, type the name of the file.
6. Click OK.

   The database file size is extended.