|
|
Posted by pankaj_wolfhunter on 05/30/06 05:39
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
Navigation:
[Reply to this message]
|