My agent’s SQL Serv­er Data­base has grown very large and I can­not deter­mine what is tak­ing up so much space. I am unable to shrink the data­base any further.

Symptoms

My agent’s SQL Serv­er Data­base has grown very large and I can­not deter­mine what is tak­ing up so much space. I am unable to shrink the data­base any further.

Problem

There may be one or more tables in your data­base that are using a large amount of space, pre­vent­ing your data­base from get­ting any smaller.

Solution

In order to shrink the data­base you need to deter­mine which, if any, tables are using extra space and delete extra rows from them if possible.

1. Open SQL Serv­er Man­age­ment Stu­dio and con­nect to the SQL Serv­er instance where your agent’s data­base is attached.

1. In Object Explor­er, right click your agent’s data­base and click Reports < Stan­dard Reports < Disk Usage By Top Tables.

1. This opens a report show­ing which tables in the data­base are using the most space. Look through the list and deter­mine which tables you may be able to free up space in. Fre­quent can­di­dates are tblWS_CallLedger and tblXML_MessageLedger. If you are unfa­mil­iar with the agent data­base struc­ture con­sult with a Visu­al Soft­ware rep before delet­ing records from the database.