By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,214 Members | 2,066 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,214 IT Pros & Developers. It's quick & easy.

mdf file become smaller and smaller after shrinking db

P: n/a
Hi all:

I restored one backup database (7.9 GB mdf) on two diffrent servers. I
shrunk them by clicking "Move pages to beginning of file before
shrinking".

After shrinking, one mdf file is 6.7 GB, and the other is 4.2GB. I
shunk again and again:
1. the 6.7GB become 5.9GB, 5.2GB, 4.7GB and 4.2Gb (four times)
2. the 4.2Gb become 4.0GB (just one more time)

It is wired, I am wondering the mdf will be smaller and smaller if I
continue to shrink them? What is the reason?

Thanks
WJ
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"willie" <w2***@hotmail.com> wrote in message
news:66**************************@posting.google.c om...
Hi all:

I restored one backup database (7.9 GB mdf) on two diffrent servers. I
shrunk them by clicking "Move pages to beginning of file before
shrinking".

After shrinking, one mdf file is 6.7 GB, and the other is 4.2GB. I
shunk again and again:
1. the 6.7GB become 5.9GB, 5.2GB, 4.7GB and 4.2Gb (four times)
2. the 4.2Gb become 4.0GB (just one more time)

It is wired, I am wondering the mdf will be smaller and smaller if I
continue to shrink them? What is the reason?
If yuo're not careful, this will eventually shrink so much it will undergo
gravitational collapse and form a blackhole.

I think this is what my ISP uses for complains about spam.

:-)

Seriously, I think Anthony may have hit the nail on the head.


Thanks
WJ

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.