468,107 Members | 1,433 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

shrink file tool from EM took all the empty space allocated to data file

SP
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
Jul 20 '05 #1
2 2865
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" <sd*********************@yahoo.com> wrote in message
news:B5******************@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

Jul 20 '05 #2
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" <ti****************************************@corner stone.se>
wrote in message news:%2****************@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" <sd*********************@yahoo.com> wrote in message
news:B5******************@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


Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Fibre Optic | last post: by
5 posts views Thread by BashiraInTrouble | last post: by
17 posts views Thread by Arnold | last post: by
32 posts views Thread by Clunixchit | last post: by
26 posts views Thread by Michel Rouzic | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.