Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SEPM Backup best practices

Created: 11 Jul 2013 | 9 comments

I recently just inherited a SEPM 12.1.3 environment and while poking around I saw that no backups were schedule to run from within the sepm console.  The sem5 database is running on a sql 08 backend with a maintenance plan that does the full/diffs on a regular schedule.  My question is about the best practices for backups.  Is it fine to allow sql to continue to handle the database backups for sem5 or should we use the backup settings in sepm to backup locally, or both?

Operating Systems:

Comments 9 CommentsJump to latest comment

Rafeeq's picture

SQL is already doing that, so no need to do from SEPM again. it would just add up space. They both do the same job.

Again its a personal decision to make

to backup from SEPM

http://www.symantec.com/business/support/index?page=content&id=TECH102836

This is for SQL

http://www.symantec.com/business/support/index?page=content&id=TECH104792

.Brian's picture

it never hurts to set a backup from the SEPM as well. There is no definitive guide but it's better to be safe than sorry.

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

pete_4u2002's picture

nothing particular, you can use both the DB. if SQL database, better use the SQL backup.

Mithun Sanghavi's picture

Hello,

Admin tab >> Servers, select your DB and click Edit DB properties

Check on the General tab

You can set the option to truncate and rebuild and set as a scheduled task.

On the backup settings tab, you may want to set it to keep only 1 backup to preserve space as well.

Check these Articles:

Best Practices to Backing up a Microsoft SQL Database on Demand from the Symantec Endpoint Protection Manager Console

http://www.symantec.com/docs/TECH96409

Symantec Endpoint Protection 12.1: Best Practices for Disaster Recovery with the Symantec Endpoint Protection Manager

http://www.symantec.com/docs/TECH160736

Symantec Endpoint Protection Manager: How is Database Maintenance scheduled?

http://www.symantec.com/docs/TECH95880 

How to manage SEPM 12.1 database.

https://www-secure.symantec.com/connect/articles/how-manage-sepm-121-database

Hope that helps!!

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.

Ambesh_444's picture

Hello,

For best answer pls check below article.

https://www-secure.symantec.com/connect/articles/how-manage-sepm-121-database

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

AjinBabu's picture

HI, 

Backing up the database and logs

Symantec recommends that you back up the database at least weekly. You should store the backup file on another computer.

The backup file is saved in the following folder, by default: Drive:\Program Files\Symantec\Symantec Endpoint Protection Manager\data\backup.

The backups are placed in a .zip file. By default, the backup database file is named date_timestamp.zip, the date on which the backup occurs.

Note:

Avoid saving the backup file in the product installation directory. Otherwise, the backup file is removed when the product is uninstalled.

Log data is not backed up unless you configure Symantec Endpoint Protection Manager to back it up. If you do not back up the logs, then only your log configuration options are saved during a backup. You can use the backup to restore your database, but the logs in the database are empty of data when they are restored.

You can keep up to 10 versions of site backups. You should ensure that you have adequate disk space to keep all your data if you choose to keep multiple versions.

The database backup might take several minutes to complete. You can check the System log as well as the backup folder for the status during and after the backup.

You can back up the database immediately, or schedule the backup to occur automatically. You can back up an embedded database or a Microsoft SQL Server database that is configured as the Symantec Endpoint Protection Manager database.

To back up the database and logs

1.    On the computer that runs Symantec Endpoint Protection Manager, on the Start menu, click All Programs > Symantec Endpoint Protection Manager > Symantec Endpoint Protection Manager Tools > Database Back Up and Restore.

2.    In the Database Back Up and Restore dialog box, click Back Up.

3.    In the Back Up Database dialog box, optionally check Backup logs, and then click Yes.

4.    Click OK.

5.    When the database backup completes, click Exit.

6.    Copy the backup database file to another computer.

To back up the database and logs from within the console

1.    In the console, click Admin, and then click Servers.

2.    Under Servers, click the icon that represents the database.

3.    Under Tasks, click Back Up Database Now.

4.    In the Back Up Database dialog box, optionally check Backup logs, and then click Yes.

5.    Click OK.

6.    Click Close.

Scheduling automatic database backups

You can schedule the database backup to occur at a time when fewer users are logged on to the network.

You can also back up the database at any time.

To schedule automatic database backups

1.    In the console, click Admin, and then click Servers.

2.    Under Servers, click the icon that represents the database that you want to back up.

3.    Under Tasks, click Edit Database Properties.

4.    In the Database Properties dialog box, on the Backup Settings tab, do the following tasks.

·         In the Backup server drop-down list, specify on which management server you want to save the backup.

·         Check Back up logs if you need to save a copy of the logs for security purposes or company policy.

Otherwise, leave this option disabled, as logs use a lot of disk space.

·         Specify the number of backups if your company policy requires it.

5.    Make sure Schedule Backups is checked, and set the schedule.

6.    Click OK.

Regards

Ajin

Chetan Savade's picture

Hi,

Thank you for posting in Symantec community.

I would be glad to answer your query.

I would suggest that let SQL handle the database maintenance. However you can take on demand backup if required.

Best Practices to Backing up a Microsoft SQL Database on Demand from the Symantec Endpoint Protection Manager Console
 
 
Backing up a Microsoft SQL database

Chetan Savade
Sr.Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<