I would like to use your script as it is far better than some thing I can write. Thanks for your contribution to DBA world. I would prefer to clean...

Thanks a bunch to all of you guys for your help and time.

issue has been resolved finally and now every thing back to normal. Learned the lesson.

make sure you select "Replace" option then it works fine.

tried for one big table and it failed as the rest of the space 4.5gb also occupied. I have added another data file on a different drive with 10gb more...

thanks guys.

appreciate all your help.

I will probably try for big 20 tables one by one and then try to generate some script for the rest of the tables.

will post the...

Tracey,

Thanks for your response. Yes, you are right.

Now I only have 4.5gb space left for data files. if I run it again with fill factor let's say 100, would it...

I am suspecting my job as all my research pointing to that one job that was running around that time. Also my hourly log backups around the time of this...

Hope this helps :

total_space: 106764.88

total_db_space: 106725.06

db_can_grow: Yes

total_log_space: 39.82

log_can_grow: Yes

total_space_used: 102041.31

total_db_space_used: 102040.30

total_log_space_used: 1.01

total_free_space: 4723.57

total_free_db_space: 4684.76

total_free_log_space: 38.81

percent_db_used: 95.61

percent_log_used: 2.54

Database Usage

Data 93921.02 MB (88.00 %)

Indexes 9346.75 MB (8.76 %)

Unused 142.45...

forgot to add the following :

Clustered(single node) SQL Server 2005 SP2 64-bit on a Windows 2003 SP1.

thanks for the script. It is beyond the best effort.

one question : I usually backup Log on hourly basis for production databases. If I use your script, every thing works...