Posted by Jack Vamvas on 06/20/06 10:28

what about initially shrinking the log , and then the data file?

--
----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________


"Zvonko" <zvonko_NOSPAM_@velkat.net> wrote in message
news:449799a2@ns1.novi-net.net...
> 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: help for shrinking database
• Prev in forum: Re: Hanging during READ_COMMITTED_SNAPSHOT ON
• Thread view: Re: help for shrinking database

[Reply to this message]