cancel
Showing results for 
Search instead for 
Did you mean: 
cccc
Level 7
Report Inappropriate Content
Message 1 of 3

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&externalId=614733&sliceI...

using Microsoft SQL Server Management Studio Express from:

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

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 ?
2 Replies

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.

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
ePO Support Center Plug-in
Check out the new ePO Support Center. Simply access the ePO Software Manager and follow the instructions in the Product Guide for the most commonly used utilities, top known issues announcements, search the knowledgebase for product documentation, and server status and statistics – all from within ePO.