September 27, 2004 at 8:16 am
HI Everybody,
I have sql server 2000 sp3 on windows 2000 server. On one of the database we have table with 130 GB data. I tried to reindex that and it grew to 240 GB. It have more than 100 GB of free space in the filegroup. I tried to shrink that file using DBCC SHRINKFILE('FILENAME') and it gave me following error
Server: Msg 3140, Level 16, State 3, Line 1
Could not adjust the space allocation for file 'Indx1_Dat'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Another thing i noticed is, it took almost 35 hours to get back with that error.
I dont have enough space available so I can export table and import it back.
Any suggestions will be appreciated.
Thank you,
September 27, 2004 at 8:54 am
shrink file can be tricky .. I often find it works best if you place the database into simple recovery model and issue a checkpoint. Try scripting the command rather than through EM.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 25, 2005 at 6:33 am
Did you ever solve this issues? We are running into the same problem!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply