We strongly recommend that you make a backup of the Sophos database before making any alterations to it. 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 backup your database you can use the script BackupDB.bat and to restore a backup you can use the RestoreDB.bat script.
Known to apply to the following Sophos product and version
Enterprise Console 5.3.1Enterprise Console 5.4.0Enterprise Console 5.4.1Enterprise Console 5.5.0
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\sophos540db.bak .\sophos SOPHOS540 backs up a SOPHOS540 database on the local SQL server (housed in a SQL instance called 'sophos') to the file C:\Windows\temp\sophos540db.bak
restoredb.bat /? displays usage options restoredb.bat C:\Windows\temp\sophos540db.bak .\sophos SOPHOS540 restores a SOPHOS540 database to local SQL server to the SQL instance called 'sophos' from the file C:\Windows\temp\sophos540db.bak Technical Information
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.