Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Backing up and restoring the Apex One SQL Server database

    • Updated:
    • 21 Nov 2021
    • Product/Version:
    • Apex One 2019
    • OfficeScan 11.0
    • OfficeScan XG.All
    • Platform:
Summary

The Apex One server can use the Microsoft SQL server database to store all customer-related information and logs. This database requires periodical or on-demand backup to prevent data loss during server migration.

Learn how to use the Microsoft SQL Server Management Studio tool to manually back up and restore the database.

Details
Public

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.

    Connect to SQL Server

    Click the image to enlarge.

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

    Back up Server

    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.

    Configure backup 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:

 
You can only restore an Apex One database that has the same Database Schema as the currently used Apex One database. For example, you cannot restore a database backup from Apex One 11.0 GM to Apex One 11.0 SP1 database.
 
  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.
  3. Right-click the Apex One database object and select Tasks.
  4. Click Restore > Database.

    Restore from backup

    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.
Premium
Internal
Partner
Rating:
Category:
Configure; Migrate
Solution Id:
1113252
Feedback
Did this article help you?

Thank you for your feedback!


*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.