Backing up the database

To back up the database:

1. On the Apex One server, stop the Apex One Master Service to prevent database modification during back up.
2. Connect to the SQL Server using Microsoft SQL Server Management Studio tool.

   

   ^{Click the image to enlarge.}

3. Right-click the Apex One database object and select Tasks.
4. Click Back Up.

   

   ^{Click the image to enlarge.}

5. Configure the settings of your backup and click OK to start the process. You can refer to Microsoft SQL Server documentation to know the recommended settings.

   

   ^{Click the image to enlarge.}

6. Find the database backup copy in the backup destination you set in the previous step.
7. Restart the Apex One Master Service.

Restoring the database

To restore the database after a failed migration:

1. On target Apex One server, stop the Apex One Master Service.
2. Connect to the SQL Server using the Microsoft SQL Server Management Studio tool.

   

   ^{Click the image to enlarge.}

3. Right-click the Apex One database object and select Tasks.
4. Click Restore > Database.

   

   ^{Click the image to enlarge.}

5. Configure the restoration settings:
   1. Select Device as the source.
   2. Choose the backup file as the source file.
   3. Select the destination database.
   4. In the Backup sets to restore section, select the backup set from your backup file.
   5. Click OK to start the process.

Backing up the database

1. On the Apex Central server, stop the Trend Micro Apex Central Service to prevent database modification during back up.
2. Connect to the SQL Server using Microsoft SQL Server Management Studio tool.

   

   ^{Click the image to enlarge.}

3. Right-click the Apex Central database object and select Tasks.
4. Click Back Up.

   

   ^{Click the image to enlarge.}

5. Configure the settings of your backup and click OK to start the process. You can refer to Microsoft SQL Server documentation to know the recommended settings.

   

   ^{Click the image to enlarge.}

6. Find the database backup copy in the backup destination you set in the previous step.
7. Restart the Trend Micro Apex Central Service.

Restoring the database

To restore the database after a failed migration:

1. On target Apex Central server, stop the Trend Micro Apex Central Service.
2. Connect to the SQL Server using the Microsoft SQL Server Management Studio tool.
3. Right-click the Apex Central database object and select Tasks.
4. Click Restore > Database.

   

   ^{Click the image to enlarge.}

5. Configure the restoration settings:
   • Select Device as the source.
   • Choose the backup file as the source file.
   • Select the destination database.
   • In the Backup sets to restore section, select the backup set from your backup file.
   • Click OK to start the process.