By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

Help Needed

P: n/a
Greetings,

I have sql server 2000 sp3 on windows 2000 server. On one
of the database we have with 40 GB data. 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 'dbfile_Dat'.
DBCC execution completed. If DBCC printed error messages,
contact your system administrator.

here the space is adequate

Can anyone help me with this?
Any help would be appreciated

TIA

May 30 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
(pa***************@yahoo.co.in) writes:
I have sql server 2000 sp3 on windows 2000 server. On one
of the database we have with 40 GB data. 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 'dbfile_Dat'.
DBCC execution completed. If DBCC printed error messages,
contact your system administrator.


If I understand this correctly, the database file is 140 GB, of which 100 GB
is unused, and you want to shrink the file to 40 GB?

Did you try specifying a target size:

DBCC SHRINKFILE('dbfile_Dat', 42000)

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.