wrote in message news:%23L1qOYhqDHA.2592@TK2MSFTNGP10.phx.gbl...
> Do you have text and image data? If so, it might be:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;308627&Product=sql
>
> I suggest you search KB for SQL Server for the word "shrink", I got hit on
> number of KB articles.
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
>
> "SP" <sdpantDeleteThisToReply@yahoo.com> wrote in message
> news:B5Qsb.35043$vn.76897@sea-read.news.verio.net...
> > I've production sql server 7 sp3 on windows NT. I had a 8GB data file
of
> > which 5GB were used and 3GB were unused. I wanted to take back the
unused
> > 3GB.
> > So I did the following with EM GUI:
> > 1. I tried to "truncate fre space from end of the file". Didn't
truncate
> > the file. I believe there was no empty space at the end of the file.
> > 2. Next I chose the option to "shrink file to 5GB". And to my horror
the
> > data file instead of taking just 5GB took the empty spaces also and the
> size
> > of the used data file went to 8GB.
> > Any idea what's going on?
> > TIA,
> > SP
> >
> >
>
>

"SP" <sdpantDeleteThisToReply@yahoo.com> wrote in message
news:B5Qsb.35043$vn.76897@sea-read.news.verio.net...
> I've production sql server 7 sp3 on windows NT. I had a 8GB data file of
> which 5GB were used and 3GB were unused. I wanted to take back the unused
> 3GB.
> So I did the following with EM GUI:
> 1. I tried to "truncate fre space from end of the file". Didn't truncate
> the file. I believe there was no empty space at the end of the file.
> 2. Next I chose the option to "shrink file to 5GB". And to my horror the
> data file instead of taking just 5GB took the empty spaces also and the
size
> of the used data file went to 8GB.
> Any idea what's going on?
> TIA,
> SP
>
>