The Sophos Community will be unavailable from 13:00 to 18:00 UTC this Saturday, October 1st for upgrades. Stay tuned to our Twitter account @SophosSupport for updates.
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 4.0.0Enterprise Console 4.5.0Enterprise Console 4.7.0Enterprise Console 5.0.0Sophos Enterprise Manager 4.7.0Sophos Control CenterEnterprise Console 5.1.0Enterprise Console 5.2.0Enterprise Console 5.2.1Enterprise Console 5.2.1 R2Enterprise Console 5.2.2Enterprise Console 5.3.0Enterprise Console 5.3.1Enterprise Console 5.4.0
For Sophos Enterprise Console 4.x/Enterprise Manager 4.x: Sophos Enterprise Console: \%programfiles%\Sophos\Enterprise Console\DB\ Sophos Enterprise Manager: \%programfiles%\Sophos\Enterprise Manager\DB\
For Sophos Control Center (SCC) \%programfiles%\Sophos\SCC\DB\
For Sophos Enterprise Console 5.x: Sophos Enterprise Console: \%programfiles%\Sophos\Enterprise Console\DB\Core\
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\sophos521db.bak .\sophos SOPHOS521 backs up a SOPHOS521 database on the local SQL server (housed in a SQL instance called 'sophos') to the file C:\Windows\temp\sophos521db.bak
backupdb.bat C:\Windows\temp\sophos4db.bak .\sophos SOPHOS4 backs up a SOPHOS4database (e.g. for Sophos Control Center) on the local SQL server (housed in a SQL instance called 'sophos') to the file C:\Windows\temp\sophos4db.bak restoredb.bat /? displays usage options restoredb.bat C:\Windows\temp\sophos521db.bak .\sophos SOPHOS521 restores a SOPHOS521 database to local SQL server to the SQL instance called 'sophos' from the file C:\Windows\temp\sophos521db.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.