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

Do you have text and image data? If so, it might be:
http://support.microsoft.com/default...27&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=d...blic.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
>
>

Thanks Tibor. Though we keep just the image file name we have text columns,
but not many. Looks like i should test with sp4. Thanks a lot.
Sp
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@corner stone.se>
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...27&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=d...blic.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
> >
> >
>
>