July 25, 2013 at 9:21 am
we have deleted some rows and released around 500 GB of space from a table. We applied filters so that this table doesn't grow beyond 600 GB. The table grew to 1.2 TB size. Now we are planning to release the space to OS as that drive holds some other database files also. But the shrink file process is taking too long. Almost 10 hours to shrink 11 GB. That database have LOBs. I am planning to shrink just one data file which has almost 400 GB of free space. I planned to add new file to the existing file group and emptying the file and dropping the old one. But the file group already contains two files and if I add a new file and do the empty file operation, to which file the data will go. Is it the new one or old one? One of the file is set to restricted growth. I am not sure how this process works? Any suggestions on how to release the free space?
July 25, 2013 at 12:53 pm
How busy that table or database is? If you have users continuously using that table and running queries all the time, it will affect the shrink process and slow it down. If you have a weekly or monthly downtime period and your request is not an urgent one, you may be better shrinking the file that time or maybe during off peaks hours.
Now, regarding to which file the data will go (assuming you have three files and you're emptying one) I think that the data will be evenly dispersed to each of them because both of them are available and they have free space. But I am not so sure about that.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply