2 Replies Latest reply on Sep 25, 2008 2:34 AM by ATS-Groep

    Backup database from EPO 4.0

      hi

      I have EPO 4.0 installed on WIN2003 server SP2 and try to backup EPO database according to:

      https://knowledge.mcafee.com/SupportSite/search.do?cmd=displayKC&docType=kc&exte rnalId=614733&sliceId=SAL_Public&dialogID=40238559&stateId=1%200%2040230791

      using Microsoft SQL Server Management Studio Express from:

      http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8 -5A0F62BF7796&displaylang=en

      but it doesn't work.

      I start SQL Server Configuration Manager, right-click on ePO server, but don't have any Tasks -> Backup Database options.
      ALL Task option is missing.

      knows someone what's wrong and howto solve this problem ?
        • 1. RE: Backup database from EPO 4.0
          this works fine for me and is how I backup.

          Did you verify that the user acount has priv's to the databases?
          If you've not done so I'd check your user priv's in SQL mgr.
          • 2. Backup with script
            Hi,
            I don't know why you don't see the task options but you can use a workaround and manually backup your ePO database.

            I personnaly made a job to backup my data every days but you can run such a script within a query ...

            USE ePO4_servername
            GO
            BACKUP DATABASE ePO4_servername TO DISK = 'd:\MSSQL\Backup\ePO4.bak' WITH FORMAT
            GO

            You can go further and add a stored procedure to your ePO database

            CREATE PROCEDURE [dbo].[spBackup]
            AS
            BACKUP DATABASE ePO4_servername TO DISK = 'd:\MSSQL\Backup\ePO4.bak' WITH FORMAT

            and then use it within a query or a job ... EXEC [dbo].[spBackup]

            Hope that it helps you

            Michel