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
Backing up the database
To back up the database:
- On the OfficeScan server, stop the OfficeScan Master Service to prevent database modification during back up.
- Connect to the SQL Server using Microsoft SQL Server Management Studio tool.
- Right-click the OfficeScan database object and select Tasks.
- Click Back Up.
- 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.
- Find the database backup copy in the backup destination you set in the previous step.
- 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.
- On target OfficeScan server, stop the OfficeScan Master Service.
- Connect to the SQL Server using the Microsoft SQL Server Management Studio tool.
- Right-click the OfficeScan database object and select Tasks.
- Click Restore > Database.
- Configure the restoration settings:
- Select Device as the source.
- Choose the backup file as the source file.
- Select the source database.
- In the Backup sets to restore section, select the backup set from your backup file.
- Click OK to start the process.
