MSSQL Database shrink.

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.



          • Related Articles

          • MSSQL database migration in v12

            Kindly follow the below steps to migrate the SQL DB, 1. Take a backup of "customer-config.xml" file from the location "ManageEngine\OpManager\conf". 2. Take a SQL backup of OpManagerDB from the old server via SQL Management Studio. 3. Create a new DB ...
          • Migration of Database from MYSQL to MSSQL in the Firewall Analyzer

            Please refer the below link for MYSQL to MSSQL migration. http://www.manageengine.co.in/products/firewall/help/appendix/migrating-data-mysql-mssql-database.html Note: I request to stop the Firewall Analyzer service and take the backup of complete ...
          • MSSQL Server migration

            1. Stop the NetFlow Analyzer service.  2. Backup the old Netflow DB and restore on to the new DB server (Connect MSSQL client using SQL Server Management Studio and backup netflow database and restore it new server). 3. From the New MSSQL SERVER, ...
          • Admin Password Reset for NetFlow Analzer with database MSSQL till build 11001

            1. Open the Management Studio on the MSSQL server 2. Select the netFlow database. Right click on netflow database and click on New Query 3. Execute the following query update AaaPassword set PASSWORD='Ok6/FqR5WtJY5UCLrnvjQQ==', SALT='12345678' from ...
          • Mysql to Pgsql/Mssql -- Plugin

            Mysql to Pgsql/Mssql  Migration Plugin: Stop Opmanager service and take a backup of the entire Opmanager folder before doing the data migration. Install Opmanager 11500 pgsql with Netflow 10250 (for mssql, select mssql DB during installation).  from ...