SQL Server Database Does Not Shrink
Overview
My agent’s SQL Server Database has grown very large and I cannot determine what is taking up so much space. I am unable to shrink the database any further.
Symptoms
My agent’s SQL Server Database has grown very large and I cannot determine what is taking up so much space. I am unable to shrink the database any further.
Problem
There may be one or more tables in your database that are using a large amount of space, preventing your database from getting any smaller.
Solution
In order to shrink the database you need to determine which, if any, tables are using extra space and delete extra rows from them if possible.
- Open SQL Server Management Studio and connect to the SQL Server instance where your agent’s database is attached.
- In Object Explorer, right click your agent’s database and click Reports < Standard Reports < Disk Usage By Top Tables.
- This opens a report showing which tables in the database are using the most space. Look through the list and determine which tables you may be able to free up space in. Frequent candidates are tblWS_CallLedger and tblXML_MessageLedger. If you are unfamiliar with the agent database structure consult with a Visual Software rep before deleting records from the database.