Shrinkfile : Server: Msg 3140, Level 16, State 3, Line 1

  • 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,

     

  • 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/

  • 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