Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 1 subscriber
  • Views 853 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Backing up the Sophos database

Pielander

Hi

We have recently installed SEC 4.5 on a Windows Server 2008 R2 server and are ready to migrate our clients to it from the old SEC 3.0 server.  This will be a new 'clean' database with new groups and policies i.e we are not migrating the old DB.  The new database is the standard SQL Express 2008 installation.  We currently back up the complete server with a typical weekly full backup and daily incrementals.

Do we need to back Sophos up any differently to this i.e do we need to schedule a daily backup of the server to a temp directory and back this up?  We have no experience of backing up SQL Express and we cannot see the DB in SQL Management Studio so can't apply our same methods as we do with a SQL 2008 DB.

Cheers!

:8699


This thread was automatically locked due to age.
  • 0

    Hello Pielander,

    as SQL Server isn't "strategic" at our site and it turned out that the nifty procedures did not always work as desired and were a pain to maintain I decided to do a daily backup of the database (using BackupDB.bat wrapped in a simple script) and let the server backup take care of the backup file. In the worst case one day will be lost - perhaps annoying but definitely not the end of the world.

    Not too long ago some other self accidentally sent much more data than intended to a place from where there is no return - as the backup file stays on disk it took just a minute to restore the database. Lost nothing more than a few hours worth of alerts. Please also take a look at Jak's post on

    Christian     

    :8703
Unfiltered HTML