April 20, 2011 at 11:28 pm
Hi All,
I have created file and filegroups and migrated the needfull objects to the new filegroups from primary.
Initially the the size of the DB was 90GB now its around 185 GB. How to reclaim the space as there are no user created objects on primary. Should i shrink the DB file? or is ther any other way. Please suggest.
April 21, 2011 at 4:59 am
If the goal was move things off a file group in order to shrink it, yeah, then you have to shrink it. SQL Server won't automatically reclaim space unless you have auto-shrink turned on (and you really shouldn't have that turned on).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 21, 2011 at 5:35 am
Thanks Grant, I was waiting for the reply. So If i use dbcc shrikfile that will reclaim the space right.
April 21, 2011 at 5:46 am
Yes, it will. Just don't make any plans around shrinking databases on a regular basis. It really causes problems.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply