cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

MSSQL 2005 Maintenance Plan and ePO Databases backup ?

The recommended maintenance plan for ePO 4.0/4.5 database using SQL Server Management Studio based on  the maintenance plan KB

found on this link

https://kc.mcafee.com/corporate/index?page=content&id=KB67184

suggests backing up only the ePO database  what I reakized that didn include the master or msdb database backup while its recommended by microsoft  to backup that database

Whats the point of backing up the ePO database through maintenance plan without backing up the maste  or the msdb database ? Is there any rational on this ?

4 Replies

Re: MSSQL 2005 Maintenance Plan and ePO Databases backup ?

Tristan
Level 15
Report Inappropriate Content
Message 3 of 5

Re: MSSQL 2005 Maintenance Plan and ePO Databases backup ?

I think McAfee are assuming that if your running MSSQL 2005 (full version not express) then your IT dept would already have a full server backup procedure in place and therefore wouldn't cover it in the KB

Re: MSSQL 2005 Maintenance Plan and ePO Databases backup ?

But should we have back up for the master and msdb  it simply checking the those dbs with in that maintenance plan they created  which on my view probably what  constitutes the difference between full recovery model and simple recovery model  may  be ?

I think the concerns based on the McAfee kb is backing up the transcation logs for all databases which may consume the disk space correct  and also add some overhead for backing up those logs and moving them out the ePO server disk space correct ?

Message was edited by: allamiro on 8/5/11 10:24:54 AM CDT
McAfee Employee spamidi
McAfee Employee
Report Inappropriate Content
Message 5 of 5

Re: MSSQL 2005 Maintenance Plan and ePO Databases backup ?

You do need to backup the system databases on a regular basis - that is always a good idea. However, the KB article is focused on ePO database and not SQL Server in general.

Microsoft's recommendations in those case will therefore apply.

More McAfee Tools to Help You
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • Visit: Business Service Portal
  • More: Search Knowledge Articles
  • ePolicy Orchestrator Support

    • Download the new ePolicy Orchestrator (ePO) Support Center Extension which simplifies ePO management and provides support resources directly in the console. Learn more about ePO Support Center