can't get the data file releasing disk space

Last Post 07 Aug 2008 10:57 PM by gonzague. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
gonzague
New Member
New Member

--
06 Aug 2008 11:51 PM
hi,
I have a 100GB database on only one datafile, which I want to split to 4 files...
I did create some additional files, an started as shrink (1,emptyfile)
the big (original) datafile did shrink (physically) to 96 GB and the new file did extent to 7 gB each.. everything was fine...

then I got an error message saying the some data souldn't be moved from original file.
I decided to create a secondary filegroup, and to move one of the very big tables to it...;
now, my secondary file group has extended to 17 GB (fine!) and my original (first) datafile is still 96 GB , but with 48% of unused space....
I would like to shrink the physical file to 50 Gb, but I can't get this file to go lower than 96GB

I tryed every shrink options etc... it run a few hours, and at the end the file is still 96GB with 48% of free space...

any suggestion?

thanks!!
gonzague
New Member
New Member

--
06 Aug 2008 11:52 PM
I just forgot to write:
SQL2005, plenty of free space on every disks (brand new dev server)
gonzague
New Member
New Member

--
07 Aug 2008 01:01 AM
here is the status of my file...


Dbld FileID CurrentSize MinimumSize Usedpages EstimatedPages
5 1 12381304 128 6323000 6323000


I think I should be able to reduce the physcial size of this file don't I?
gonzague
New Member
New Member

--
07 Aug 2008 10:57 PM
hi,
thank you for the answers...

I am the only user on the database, the recovery model is set to simple...
I just updated usage, the shrink took 25s before display same stats:

5 1 12381304 128 6321448 6321448

I just fullbakup / restore then a shrink....
..still the same

(I forgot to mention that there are some text fields in this database... could it makr this file 'unshrinkable')?
You are not authorized to post a reply.

Acceptable Use Policy