Summary
Reduce the size of the IMSS database when you encounter any of the following scenarios:
- The disk where the IMSS database is located is almost full.
- The IMSS database is about to reach the size limit of SQL Express servers.
Details
Back up the IMSS and EUQ databases
This will allow recovery in case unexpected problems arise.
- Stop all IMSS services.
- Open a command prompt and then type "osql.exe -U sa".
- Type the password.
- Create a backup of the IMSS database.
- At 1>, type the following command:
backup database imss to disk='c:\imss.bac'
- At 2>, type "go".
A message that the database backup is complete will appear.
- At 1>, type the following command:
- Create a backup of the EUQ database.
- At 1>, type "backup database imsseuq to disk='c:\imsseuq.bac'".
- At 2>, type "go".
A message that the database backup is complete will appear.
- At 1>, type "quit" to exit the OSQL command interface.
- Start the IMSS services.
Reduce the size of the database
- Open the IMSS web console.
- Go to Logs > Settings.
- Go to the Number of days to keep logs for query field and select the lowest value allowed in your company policy.
- Click Save.
- Go to Administration > User Quarantine Access.
- Go to the Keep quarantined spam for field and select the lowest value allowed in your company policy.
- Click Save.
- Close the IMSS console.
- Using an administrator account, go to the <IMSS>/bin folder and run the dblog_janitor.exe file.
The process will finish after a few minutes. - Stop all IMSS services.
- Run the following command:
osql.exe -E
use imss
go
dbcc shrinkdatabase(imss)
go
