Unmount and Defrag Individual Database in Storage Group
Posted on 2006-05-30
We currently have three databases in a single storage group. We have our private database, our public database, and a journaling database which contains archived copies of all email in the private database and the contents of that get sent nightly to an offsite system. The journaling database has been collecting mail for a long time now and has grown quite large though it doesn't need to keep any messages once they have been sent offsite. I've set it up for Mailbox Management to purge anything older than 30 days and now I would like to run an offline defrag on that database to shrink the file size. Is it possible to just take a single database offline or must I take the entire storage group offline? Also if I can just shutdown that single database what will happen to the messages that are archived from the private database to the journaling database while the journaling database is offline? Do they just queue up and go once it's brought back online or are they gone forever?