Planning for Microsoft SQL database creation and management with Symantec Endpoint Protection 11.x

Article:TECH105256  |  Created: 2008-01-30  |  Updated: 2009-01-08  |  Article URL http://www.symantec.com/docs/TECH105256
Article Type
Technical Solution


Issue



You want more details concerning the creation and management of the Microsoft SQL database for use with the Symantec Endpoint Protection Manager (SEPM).


Solution



Below is a list of available information concerning Microsoft SQL 2000 and 2005 database creation and management for use with the SEPM.


Manual Creation of the SQL Database:
Please refer to the following documentation for the manual creation process:

"Symantec Endpoint Protection Manager: How to create and use a custom SQL 2005 database and user." at:
http://service1.symantec.com/support/ent-security.nsf/docid/2008052215175648

The specific SQL parameters will vary based on your environmental needs. Refer to the example and the Database Planning sections below.

For reference, below is an example of the SQL script used to generate the SQL Database used for the Symantec Endpoint Protection Manager.
    CREATE DATABASE sem5 ON PRIMARY
      ( NAME = sem5,
      FILENAME='C:\Program Files\Microsoft SQL Server\MicrosoftSQL.1\MicrosoftSQL\DATA\sem5.mdf',
      SIZE = 90,
      MAXSIZE = 20000,
      FILEGROWTH = 64),

    FILEGROUP FG_CONTENT
      (NAME = sem5_content,
      FILENAME='C:\Program Files\Microsoft SQL Server\MicrosoftSQL.1\MicrosoftSQL\DATA\sem5_content.ndf',
      SIZE = 850,
      MAXSIZE = 20000,
      FILEGROWTH = 64),

    FILEGROUP FG_INDEX
      (NAME = sem5_index,
      FILENAME='C:\Program Files\Microsoft SQL Server\MicrosoftSQL.1\MicrosoftSQL\DATA\sem5_index.ndf',
      SIZE = 400,
      MAXSIZE = 20000,
      FILEGROWTH = 64),

    FILEGROUP FG_LOGINFO
      (NAME = sem5_loginfo,
      FILENAME='C:\Program Files\Microsoft SQL Server\MicrosoftSQL.1\MicrosoftSQL\DATA\sem5_loginfo.ndf',
      SIZE = 350,
      MAXSIZE = 20000,
      FILEGROWTH = 64),

    FILEGROUP FG_RPTINFO
      (NAME = sem5_rptinfo,
      FILENAME='C:\Program Files\Microsoft SQL Server\MicrosoftSQL.1\MicrosoftSQL\DATA\sem5_rptinfo.ndf',
      SIZE = 32,
      MAXSIZE = 20000,
      FILEGROWTH = 64)

    LOG ON
      (NAME = sem5_log1,
      FILENAME='C:\Program Files\Microsoft SQL Server\MicrosoftSQL.1\MicrosoftSQL\DATA\sem5_log1.ldf',
      SIZE = 128,
      MAXSIZE = 4096,
      FILEGROWTH = 64),
      ( NAME = sem5_log2,
      FILENAME='C:\Program Files\Microsoft SQL Server\MicrosoftSQL.1\MicrosoftSQL\DATA\sem5_log2.ldf',
      SIZE = 128,
      MAXSIZE = 4096,
      FILEGROWTH = 64)


SQL Database Schema Information:
Please refer to the following "DB_Schema_Ref_Guide.pdf" for the database schema information.

DB_Schema_Ref_Guide.pdf


Database Planning:
Please refer to the following "SEPM Estimation of Database Storage.xls" for information on projected database sizes based on management volume.
SEPM Estimation of Database Storage.xls

The following "Symantec Endpoint Protection Database Sizing Tool.xls" is a non-supported tool provided for customer convenience to assist in estimating database size.

Symantec Endpoint Protection Database Sizing Tool.xls





Legacy ID



2008063014073748


Article URL http://www.symantec.com/docs/TECH105256


Terms of use for this information are found in Legal Notices