Posted by Cimode on 06/20/06 12:12

Do not forget to do some backup B4 the operation...
Jack Vamvas wrote:
> 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: Hanging during READ_COMMITTED_SNAPSHOT ON
• Prev in forum: Re: Connecting Sql Server 2005 from ASP?
• Thread view: Re: help for shrinking database

[Reply to this message]