• Gails advice here is correct most of the time. In NORMAL use a database stabalises at a particular size.

    HOWEVER if you know your database is normally 50% fulll at 1GB and you took exceptional action that took it to 10GB, and you now have 50% of 1GB again you should shrink back to 1GB.

    This should remove any O/S fragmentation created above 1GB.

    Tim

    .