cant shrink data file

sql2k sp3
Before I start, let me assure you that the 5 gigs of free
space in my db is in the data file, not the log file. I
already shrunk the 7 gig log file with no problem. Now
when I run dbcc shrinkfile(db_data_file) it runs for a
long time and then barely shrinks anything. Am I missing
something here? Any ideas?
Thanks in advance.Chris,
You may need to check for fragmentation.Refer DBCC SHOWCONTIG, DBCC
INDEXDEFRAG in BooksOnLine.
Also, may be..
PRB: DBCC SHRINKFILE and SHRINKDATABASE Commands May Not Work Because of
Sparsely Populated Text, Ntext, or Image Columns
http://support.microsoft.com/default.aspx?scid=kb;en-us;324432
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"chris" <chrisr@.fingps.com> wrote in message
news:3bbe01c37626$d832d270$a301280a@.phx.gbl...
> sql2k sp3
> Before I start, let me assure you that the 5 gigs of free
> space in my db is in the data file, not the log file. I
> already shrunk the 7 gig log file with no problem. Now
> when I run dbcc shrinkfile(db_data_file) it runs for a
> long time and then barely shrinks anything. Am I missing
> something here? Any ideas?
> Thanks in advance.
>|||If you want to see where your data is allocated through the data file go to
www.sqlfe.com. You can see what is at the end of the data file.
--
Barry McAuslin
support@.sqlfe.com
http://www.sqlfe.com
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%23PZlOfidDHA.828@.TK2MSFTNGP11.phx.gbl...
> Chris,
> You may need to check for fragmentation.Refer DBCC SHOWCONTIG, DBCC
> INDEXDEFRAG in BooksOnLine.
> Also, may be..
> PRB: DBCC SHRINKFILE and SHRINKDATABASE Commands May Not Work Because of
> Sparsely Populated Text, Ntext, or Image Columns
> http://support.microsoft.com/default.aspx?scid=kb;en-us;324432
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "chris" <chrisr@.fingps.com> wrote in message
> news:3bbe01c37626$d832d270$a301280a@.phx.gbl...
> > sql2k sp3
> >
> > Before I start, let me assure you that the 5 gigs of free
> > space in my db is in the data file, not the log file. I
> > already shrunk the 7 gig log file with no problem. Now
> > when I run dbcc shrinkfile(db_data_file) it runs for a
> > long time and then barely shrinks anything. Am I missing
> > something here? Any ideas?
> > Thanks in advance.
> >
> >
>