Did you delete any items from Manage > Items within Protect prior to running the shrink? The records need to actually be deleted through Protect before running the shrink will do much.
Also, it can help to set the recovery model to simple for the database - within SQL management studio right click on the Protect database > Properties > Options > Recover Model > set to Simple.
I hope that helps.
I did perform the delete items. Green progress bar appears, says items are being deleted, then nothing happens. All of the records are still there. I have also set the recovery model to Simple mode as well.
Thank you for the fast response.
1 of 1 people found this helpful
It would probably be good to check Protect's logs to see if there are any errors connecting to SQL or with the console service operations.
This doc shows where the logs are:
You could look through the logs yourself if you like (I'd suggest starting with whatever is the newest based on last modified date), or you could zip and send the logs. If you're ok with posting on here I'll review the logs, otherwise I'd suggest opening a support case at http://support.shavlik.com.
Another thing you could try is to close Protect, go to Start > All Programs > Shavlik Protect > Database setup tool and re-establish the connection to the existing database. This will also automatically restart the Shavlik Protect console service during this process. Then open Protect and see if deleting items works.
I ran the database setup tool and the connection test is successful. I then proceeded to complete the setup and recieved the following:
Database Installation error: Failed to commit the database installation or upgrade.
Is the SQL server where you have your Protect database local or remote?
Have you tried rebooting the Protect console system?
This document could possibly help:
Do you have a backup of the database at all? I have seen this issue resolved previously by restoring a backup of the Protect database.
I was able to resolve my issue, but it was not ideal. I had to create a new database and copy data from the old. I appreciate the assistance you have provided.