July 13, 2010 at 4:40 am
Hi,
Can anyone help please?
I am trying to shrink a database filegroup which contains TEXT data only. It was set up using ' TEXTIMAGE_ON [filegroup]' in my table schemas, to keep the text data on seperate disks, unfortunatelly the usage was underestimated, and data has filled the filegroup space reserved.
The filegroup is 300GB but has around 50GB free after I archived some data, I need to release this free space back to the O/S.
I am reading articles which suggest that there may be a problem shrinking this data type. Is this true? Or are there any other suggestions?
Any help appreciated. 🙂
Thanks
Paul
July 13, 2010 at 4:54 am
Paul A (7/13/2010)
The filegroup is 300GB but has around 50GB free after I archived some data, I need to release this free space back to the O/S.
Why?
What's wrong with leaving the 50GB in the file for future growth?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 13, 2010 at 5:37 am
There is now regular archiving set up on the database, so it will only populate the around 200GB of the 250Gb allocated, after the shrink.:-)
July 13, 2010 at 5:53 am
Do you really need the disk space that badly ? , it is good practice to leave a bit of room for growth..
July 13, 2010 at 6:53 am
Unfortunatelly disk space is at an absolute minimum, and I need to use the free space for other purposes. This is SAN attached storage, and I am awaiting other disks to be installed.
Does anyone know how to shrink the filegroup? 🙂
July 13, 2010 at 6:57 am
DBCC SHRINKFILE, like you would any other file.
I suggest a reorganise of the clustered index with LOB_COMPACTION on first.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply