Change the Location of the CommServe Database Files

Overview

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

For example, 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.

Procedure

On the CommServe computer, perform the following steps to change the location of the CommServe database files.

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

  1. 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. Once the Disaster Recovery (DR) backup job completes, copy the DR backup files (located in the set_XXX folder under your DR directory) to an secure location.
  2. Stop the services:
    1. Click the Start button on the Windows task bar and then click All Programs.
    2. Go to ##_DOC_OEM_INSTALL_DESTINATION_COMPANY_FOLDER_## 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. Detach the database:

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

    1. From the Object Explorer pane, go to Server Instance > Databases.
    2. Right-click CommServe and then click Properties.
    3. From the Database Properties dialog box, select the Files page on 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/CommServe folder.

    1. Open the Microsoft SQL Server Management Studio.
    2. From the Object Explorer pane, go to Server Instance > Databases.
    3. Right-click CommServe, and then click Tasks > Detach.

      The Detach Database dialog box appears.

    4. Click OK.
  4. 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.
  5. Attach the database to the new location:
    1. Open the Microsoft SQL Server Management Studio.
    2. From the Object Explorer pane, go to Server Instance > Databases.
    3. Right-click Databases, and then click Attach.

      The Attach Databases dialog box appears.

    4. Click Add.

      The Locate Database Files dialog box appears.

    5. 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.

    6. In the Owner column, select sa as the owner for the database.
    7. Click OK.

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

  6. Start the services:
    1. Click the Start button on the Windows task bar and then click All Programs.
    2. Go to SnapProtect and then click Process Manager.
    3. From the Process Manager dialog box, right-click the All Services node and then click Start.