Hi Keith,

The recovery model is set to Full and yes, we have a maintenance plan for backup and reindexing. We manually execute the Shrink Database if needed.

Below is the settings for the data and logfiles prior to this problem
Data File (Autogrowth = 10%)
Log File (Autogrowth = 10%)

Currently, the new database and logfiles autogrowth are set to the following
Data File (Autogrowth = 1MB)
Log File (Autogrowth = 10%)


The Logfile is automatically being shrunk everytime we do a backup. The bulk of it is in the datafile. We also noticed on all tables that the index size is far greater than the data size. One of our tables consist of 800MB on its data size and 1.8 GB on its index size. Even if we do a full reindexing on these tables, the ratio between the data and index size still remains. Is it a normal case that the index size is greater than the data size?

Please advice
Thank you in advance...