Critical System Protection

Hi,

I would like to know how do we schedule a shrinking of Database at SQL Server 2008 for scsp_logs?

I see the solution provided by Chuck Edson in the below symantec connect discusson. However i so not see the doc which was attached earlier.

Can i get that doc please...

https://www-secure.symantec.com/connect/forums/symantec-critical-system-protection-sql-server-2008-how-schedule-shrinking-database

Thanks in advance.

Which Doc are you looking for?

http://www.symantec.com/docs/TECH112966  (How to [manually] purge events from the Symantec Critical System Protection 5.0 database)

There is a built-in feature that runs the above automatically..  

See:  http://www.symantec.com/business/support/index?page=content&id=TECH116375 (Enabling Purge Events in the Symantec Critical System Protection (SCSP) 5.2.3 Management Console Generates Errors in Sis-server.0.log).

Could you please tell me on how to perform this below commands (including the navigation)?

Example: Removing old events
The following example removes all Symantec Critical System Protection events that are dated March 10, 2006 and earlier:
 

• USE SCSPDB
  DELETE FROM CSPEVENT WHERE EVENT_DT<= '2006-03-10 23:59:59:999'

Example: Removing new events
The following example removes all Symantec Critical System Protection events that are dated February 3, 2006 and later:
 

• USE SCSPDB
  DELETE FROM CSPEVENT WHERE EVENT_DT>= '2006-02-03 00:00:00:000'

login into SQL management studio, and run those queries. take the DB backup before running the query.