Administrator's Guide

Truncate Table Auditlog
Truncate Table History
d. Click Execute.
You should see Command(s) completed successfully In the messages section.
2. Shrink the database:
a. Open SQL Server Management Studio and expand the Databases folder.
b. Right-click on SAM database, and select Tasks > Shrink > Files.
c. In the File type list, select Data.
d. In the Shrink action section, select Reorganize pages before releasing unused space.
e. Set the Shrink file size to the default 100MB.
f. Click OK.
3. Verify that you have a 100MB SAM_data.mdf file.
NOTE: The default file location is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
\Data.
26 Chapter 3 Installation ENWW