April 5, 2012 at 3:33 pm
I have a 2008 database that is 1.8TB. We changed the amount of data that must be retained so about 45% of the filegroup is now free. I want to shrink the data file to 1TB. That will still keep about 50GB for growth which should be more than enough.
What is the best way to free up this space?
April 5, 2012 at 3:56 pm
You will have a 1 TB database and want to shrink to leave only 50GB free?
What is the size of your largest table?
You should not shrink the database to a point where less than 1.5 - 2x largest table size is left available in free space.
So if you have a table that is 50GB, you should leave ~ 100GB free space in the data file. This is for index maintenance operations.
Also, how long will that 50GB allow you to run your production environment before you will need to grow the database?
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
April 5, 2012 at 4:21 pm
This is a repository that collects the Event logs for all of our Windows servers. We have reduced the kinds of events that are being logged and the number of months being retained. Rather than purging the existing data, we let it age and fall off on it's own. The size of the database is fairly constant plus or minus about 20GB but I get your point.
Please don't loose site of my question. How do I free up the unused 700+GB of space currently allocated to the data file that will never be needed by this database?
April 5, 2012 at 4:27 pm
DBCC Shrinkfile.
I would do it in stages - reduce it by 100-200GB each stage.
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
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply