Overnight, I had a Rebuild Index job run and it grew the size of the database.mdf file approximately 4 times. 300MB to 1.2GB. It also changed the initial size of the database to 1.2GB. Is there any way to recover this space or to shrink the database?
I tried to shrink it with DBCC SHRINKDATABASE to no avail (only recovered 40MB).
Do I have any options to reclaim the space?
Any ideas?
Thanks.It turns out that the cause of the increase in size of database files was due to the fact that I had the Rebuild Index job set with a fill factor of 10%. I tested a bit and found that if I set it to reorganize pages with the default amount of free space that it didn't triple/quadruple/etc the size of the files.
Case Closed!
No comments:
Post a Comment