More than likely there are not enough contiguous empty pages for SQL Server to release the space. To free up the space, you will probably need to move each of the indexes to a new file (or the other drive) and then shrink the file.

Kevin Martin
Database Engineer
Multimedia Games, Inc.



-----Original Message-----
From: Medjamia, Mehenna [mailto:Mehenna.[Email Address Removed] Wednesday, April 28, 2004 9:59 AM
To: LazyDBA.com Discussion
Subject: Help with shrinking a SqlServer file


Hi,

I would appreciate if someone can help with this issue:

I have an index file called Index_file.ndf which is 177 GB in size.

because of disk space issue on the current drive. I have moved a couple of
indexes onto a different drive. This has technically freed 70 GB which I
want to release to the operating system for other files to use.

But each time a run dbcc shrinkfile with the file id for index_file.ndf.

it takes ages and it doesn't change anything Index_file is still 177GB.

Is there any thing else I could do to free this 70GB for other file to use.

Many Thanks

M&M


This communication contains information which is confidential and may be
legally privileged and is for the exclusive use of the addressee(s). If you
are not a named addressee please contact the sender immediately, and delete
the communication from your system. You are hereby notified that any
disclosure, distribution or copying of this communication, in whole or in
part, is strictly prohibited. Any views or opinions presented are solely
those of the author and do not necessarily represent those of the Company,
its directors or officers unless otherwise specifically stated. The Company
is not responsible for any reliance placed on the information contained
herein and excludes all liability.

(c)Copyright 2003 Siemens Energy Services Limited. All Rights Reserved.

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
then respond to the confirmation email you get
For additional commands, e-mail: mssqldba-[Email Address Removed] mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.670 / Virus Database: 432 - Release Date: 4/27/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.670 / Virus Database: 432 - Release Date: 4/27/2004

MS Sql Server LazyDBA home page