November 17, 2014 at 11:15 am
I have this database in SQL 2008R2 with 128 GB of size,
I cleaned the database and the datafiles size is now around 67 GB,
is there any way I can take that space back,
Help is appreciated,
Regards,
Bubby
November 17, 2014 at 11:44 am
Well do you expect the database to grow in size again?
November 17, 2014 at 12:00 pm
No
November 17, 2014 at 12:28 pm
You can use dbcc shrinkfile. I would leave 20GB free space inside of the file to allow for various database activities including growth.
The problem with shrinking a file is that it will fragment the indexes in the database to nearly 100% fragmentation.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 17, 2014 at 5:24 pm
If you shrink the data file, you must rebuild your indexes in order to fix the fragmentation.
Leave enough space for the index rebuild (approx. the size of the largest table).
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply