MSSQL Database shrink.

To reduce the MSSQL database size, please follow the below steps.

1. Stop the NetFlow Analyzer service.

2.Open a command prompt as administrator(Right click and run as administrator) Navigate to <NetFlow_Home\troubleshooting\>.

3. Execute the following command:

rawCleanup.bat

4. Open the SQL server Management studio

5. Then right click on the database and click on properties and under options keep the Recovery Mode as Simple.

6.Select the database "netflow"

7.  Execute the following query.

    DBCC SHRINKFILE (netflow_log, 10);
    DBCC SHRINKFILE (netflow, 50);

8. Start the NetFlow Analyzer service.

9. Login to the UI and navigate to Admin -> Storage Settings -> Raw Data Settings -> Retain Raw Data to lowest time period and update.