Posted by Zvonko on 06/20/06 06:44

Hi guys.

I have a huge database file. When I run sp_spaceused this are the
results:

db_size 1337,31 Mb
unallocated 14,62 Mb
reserved 1088456 Kb
data 258992 Kb
index_size 6224 Kb
unused 823240 Kb

Now, when I run dbcc shrinkfile(database_name, 50) or whatever value of
percent, it says there is not enough free space in db.

Please advice how to shrink the size of that file and why is it so big?

Thanks in advance

Zvonko

• Next in forum: Re: Hanging during READ_COMMITTED_SNAPSHOT ON
• Prev in forum: Re: Hanging during READ_COMMITTED_SNAPSHOT ON
• Thread view: help for shrinking database

[Reply to this message]