How to Shrink the SCSP database or one of its files?

book

Article ID: 159103

calendar_today

Updated On:

Products

Critical System Protection Data Center Security Server Critical System Protection Client Edition Data Center Security Server Advanced

Issue/Introduction

The SCSP database is growing or is full and you want to shrink the dartabase or one of its data files.

Resolution

Use the following SQL query, to find the logical name of the file that you want to shirnk:

USE SCSPDB
EXEC sp_helpfile
 
Once you find the logical name in the result of the above query, run the following command:
 
DBCC SHRINKFILE (scspevents)