Backing up the Sophos EM database

Question

We are running enterprise manager 3.1.0.24.76.. From what I can see it's running some old version of MSSQL 2000? Is that MDAC? I can't get Expressmaint to back it up. I'm not having any luck getting MMSQL Server 2005 Managment console to connect to it. My goal here is to automate a backup of it at night so our tape system can get the backup.

Is this possible? Is there an easier way?

- Joe

This thread was automatically locked due to age.

OD · Accepted Answer

Hi Joe,

Enterprise Console 3 has a backupdb.bat batch file you can use to do this.

It is located in %programfiles%\sophos\enterprise console\db\

In CMD run backupdb on its own to get parameters.

e.g. backupdb c:\backups\mydb.bak

To restore, you can use restoredb.bat

So a scheduled task could do this.

Hope that helps :)

OD