mdf file become smaller and smaller after shrinking db

[willie]

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

[Greg D. Moore \(Strider\)]

"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