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

SQL server 2008/2012 maintenance tasks for SEP 11/SEP 12

Created: 25 Feb 2013 | 9 comments
ThaveshinP's picture

I am not a SQL expert. Does symantec have best practices or maintenance tasks that the SQL DBA's should run regularly on SEP 11/SEP 12 databases.

We want to optimize the SEP DB as much as possible and need specifics to give to the SQL DBA's. We are running SQL 2008 for SEP 11 and SQL 2012 for SEP 12.

Anyone find the optimal settings ?

Comments 9 CommentsJump to latest comment

Ajit Jha's picture

Hi,

Same here, not an expert on SQL side, but found some useful articles for you.

Maintaining the database

http://www.symantec.com/business/support/index?pag...

Database maintenance tasks

http://www.symantec.com/business/support/index?pag...

Regard's

Ajit Jha

Technical Consultant

ASC & STS

Mithun Sanghavi's picture

Hello,

Check these Articles:

Scheduling automatic database maintenance tasks

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

Excluding Microsoft SQL Server files and folders using Centralized Exceptions

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

Create database maintenance plans in MS SQL Server 2005 using SQL Server Integration Services (SSIS)

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

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.

ThaveshinP's picture

Why is Symantec still stuck on SQL 2005? Is there no documentation on SQL 2008 or 2012 - it is a supported platform. What can we tell the SQL DBA's to do to make sure that the SEP database runs smoothly ? Does no one bother about the database then,

Mithun Sanghavi's picture

Hello,

SQL 2008 and 2012 are both supported.

Secondly, check this Article:

How to install the Symantec Endpoint Protection Manager using Windows Authentication and SQL Server 2008

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

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.

John Santana's picture

So is this SQL server maintenance mandatory or no need to worry about it ?

I'm running SQL Server 2005 SP4 and the database size is just 6 GB for 800+ clients.

Kind regards,

John Santana
IT Professional

--------------------------------------------------

Please be nice to me as I'm newbie in this forum.

OmerCh's picture

I believe planning is the key,

1- Decide how many revisions you want to maintain on your infrastructure

2- Use GUP wherever possible

3- Rebuild indexes regularly (better schedule them)

4- If this SQL instance is part of centralized SQL cluster, discuss every minor detail with your DBA to finalize the maintenace operations.

ThaveshinP's picture

So -Symantec does NOT have best practices to maintain the SEP database at all. We have to rely on the SQL DBA's. Wish all vendors could be safe in the knowledge that the SQL DBA's will maintain it properly.