Reduce 1Gb database to 100Mb

Question

From responses here, it seems that I need to reduce my database size in order to benefit from the reduced charges (I am actually using less than 15Mb, so can make us of the new 100Mb sizing option).

Can I just do a MAXSIZE on an ALTER DATABASE ?

If I can, then the 100Mb option is not yet reflected in the MSDN article on the subject.

If it is possible, what would be the syntax to specify 100Mb? 

If it's not ALTER DATABASE, then what's the way to get an existing 1Gb database downsized to 100Mb?

Thanks,  Nick.

Answer 1

Nick, billing is based on actual size and not on MAXSIZE.

If your invoice has any problem please contact customer support.

---

If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Best Regards.