> Documentation > CommCell Management > CommServe Administration

Changing the Location of the CommServe Database Files

You can change the drive and directory location of the CommServe database files using the SQL Server Management Studio.

This is useful if the drive where the database resides is running out of space or if the drive was corrupted. You can use this procedure to move the database files to another drive.

Important

Other Commvault features might create and use additional databases, such as DM2 (for Web Server) and WFEngine (for Workflow Engine). To completely transition the Commvault instance to another disk, you must move all the databases. Check the Commvault instance from the Object Explorer pane in the Microsoft SQL Server Management Studio to determine all the installed databases.

Procedure

  1. On the CommServe computer, run a Disaster Recovery backup:

    1. From the CommCell Browser, right-click the CommServe node and then click All Tasks > Disaster Recovery Backup.

      The Disaster Recovery Options dialog box appears.

    2. Click OK.

    3. After the Disaster Recovery (DR) backup job completes, copy the DR backup files (located in the set_XXXX folder under your DR directory) to a secure location.

  2. Stop the services:

    1. Click the Start button on the Windows task bar and then click All Programs.

    2. Go to Commvault and then click Process Manager.

    3. From the Process Manager dialog box, right-click the All Services node and then click Stop.

    4. From the pop up window, click Yes to stop all services.

  3. Before detaching the database, note the location of the database files using the Microsoft SQL Server Management Studio:

    1. Open the Microsoft SQL Server Management Studio.

    2. From the Object Explorer pane, go to server_instance > Databases.

    3. Right-click CommServ and then click Properties.

    4. From the Database Properties dialog box, click the Files page in the left pane.

      Under the Path column, you can see the path where the database files reside.

      By default, the database files are located in the software_installation_directory/Data/CommServ folder.

  4. Detach the database:

    1. From the Object Explorer pane, go to server_instance > Databases.

    2. Right-click CommServ, and then click Tasks > Detach.

      The Detach Database dialog box appears.

    3. Click OK.

  5. Copy the database files to the new location:

    1. Navigate to the drive or directory where you want to move the database and create a new directory for the database files.

    2. Copy the database files to the newly created directory.

  6. Attach the database to the new location:

    1. From the Object Explorer pane, go to server_instance > Databases.

    2. Right-click Databases, and then click Attach.

      The Attach Databases dialog box appears.

    3. Click Add.

      The Locate Database Files dialog box appears.

    4. Navigate to the drive/folder where you copied the database files, select the .MDF file, and then click OK.

      The database is listed under the Databases to attach section in the Attach Databases dialog box.

    5. In the Owner column, select sa as the owner for the database.

    6. Click OK.

  7. If you have other databases installed on the CommServe computer, such as DM2 or WFEngine, repeat the preceding steps to move the respective databases to a different path.

  8. Start the services:

    1. Click the Start button on the Windows task bar and then click All Programs.

    2. Go to Commvault and then click Process Manager.

    3. From the Process Manager dialog box, right-click the All Services node and then click Start.

Loading...