Trend Micro - Securing Your Journey to the Cloud Business
Support
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 OfficeScan SQL Server database

    • Updated:
    • 7 Aug 2018
    • Product/Version:
    • OfficeScan 11.0
    • OfficeScan XG.All
    • Platform:
    • Windows 2008 Server R2 Enterprise
    • Windows 2008 Standard
    • Windows 2008 Standard 64-bit
    • Windows 2012 Enterprise
    • Windows 2012 Enterprise R2
    • Windows 2012 Standard
    • Windows 2012 Standard R2
    • Windows 2016 Server Core
    • Windows 2016 Server Datacenter
    • Windows 2016 Server Standard
Summary

The OfficeScan 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 OfficeScan server, stop the OfficeScan Master Service to prevent database modification during back up.
  2. Connect to the SQL Server using Microsoft SQL Server Management Studio tool.

    Microsoft SQL Server Management Studio tool

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

    Back up the database

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

    Configure backup settings

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

Restoring the database

To restore the database after a failed migration:

 
You can only restore an OfficeScan database that has the same Database Schema as the currently used OfficeScan database. For example, you cannot restore a database backup from OfficeScan 11.0 GM to OfficeScan 11.0 SP1 database.
  1. On target OfficeScan server, stop the OfficeScan Master Service.
  2. Connect to the SQL Server using the Microsoft SQL Server Management Studio tool.
  3. Right-click the OfficeScan database object and select Tasks.
  4. Click Restore > Database.

    Restore database

  5. Configure the restoration settings:
    1. Select Device as the source.
    2. Choose the backup file as the source file.
    3. Select the source 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
Rating:
Category:
Configure; Migrate
Solution Id:
1113252
Feedback
Did this article help you?

Thank you for your feedback!

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.

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.
Related Articles