We strongly recommend that you make a backup of the Sophos databases before making any alterations. Note: For reference, article 17323 lists the database names associated with the version of the console.
This article is not applicable to PureMessage databases.
To back up your database you can use the script BackupDB.bat and to restore a backup you can use the RestoreDB.bat script.
Applies to the following Sophos products and versions Enterprise Console 5.5.0Enterprise Console 5.5.1Enterprise Console
Note: If you have run the Enterprise Console installers previously, the batch files can also be found in the following location, providing the default location was not changed: "C:\sec_[Version]\ServerInstaller\DB\".
If you do not know the name of the instance in which the Sophos database is installed, follow the instructions in How to check which SQL instance your Enterprise Console database is installed in to find out.
Restore the Sophos database
Examples backupdb.bat /? displays usage options backupdb.bat C:\Windows\temp\sophos550db.bak .\sophos SOPHOS550 backs up a SOPHOS550 database on the local SQL server (housed in a SQL instance called 'sophos') to the file C:\Windows\temp\sophos550db.bak
restoredb.bat /? displays usage options restoredb.bat C:\Windows\temp\sophos550db.bak .\sophos SOPHOS550 restores a SOPHOS550 database to local SQL server to the SQL instance called 'sophos' from the file C:\Windows\temp\sophos550db.bak
If you've spotted an error or would like to provide feedback on this article, please use the section below to rate and comment on the article. This is invaluable to us to ensure that we continually strive to give our customers the best information possible.
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. For technical support post a question to the community. Or click here for new feature/product improvements. Alternatively for paid/licensed products open a support ticket.