none
Suggest Reqd for Archive Mailbox Database and the Default Mailbox Database

    Question

  • Hello Team

    In my Lab Exchange 2010 DAG , having normal mailbox database (Default One) and Archive mailbox databases in the same drive

    The Default database size is currently 10GB and

    What happens

    I moved all the emails from the users mailboxes located in default database  to archive mailboxes and now Archive Mailboxdatabase size keeps increasing whenever I moved the emails from default mailbox database to Archive Database., that is natural I understand

    But at the same time, I would like to regain the size of the Default database size either by running offline defragment or by creationg the new database and move the mailboxes form the current default database to the new database.

    I understand, offline defrag requires the DB offline and may take some time  , but which is the best way since both the DB’s are located in the same drive

    Best practice is, creating the new database and move the mailboxes form the current default database to the new database. – am I right

    How do I defrag in DAG – in case of worst scenario

    Please suggest

     

     

     

                                                                                                                                                                                                                                                



    ramakrishnan

    Friday, July 19, 2013 4:32 PM

Answers

  • Good Afternoon,

    Since its a lab.. it may make sense to blow it up and do it correctly from the beginning. That's how you master it.

    Best practice is actually the DB during setup.. --> Setup.com /roles: {roles} M /MdbName: {Database Name}

    However, you can move the mailboxes and you defrag the DB as shown in my blog link below. 

    Personally.. I think you should blow it up and do it correctly.. What you do on the practice field determines how you do on the playing field.

    http://thelifestrategist.wordpress.com/2013/07/14/database-maintenance-and-management/



    Dame Luthas, ITILv3, MCSE Messaging 2013, MCSA, MCITP

    My Technical Blog: http://thelifestrategist.wordpress.com/

    Discipline is the Difference between Goals and Accomplishments..

    • Proposed as answer by Dame Luthas Friday, July 19, 2013 5:48 PM
    • Marked as answer by rush2ramki Saturday, July 20, 2013 4:05 PM
    Friday, July 19, 2013 5:48 PM

All replies

  • Good Afternoon,

    Since its a lab.. it may make sense to blow it up and do it correctly from the beginning. That's how you master it.

    Best practice is actually the DB during setup.. --> Setup.com /roles: {roles} M /MdbName: {Database Name}

    However, you can move the mailboxes and you defrag the DB as shown in my blog link below. 

    Personally.. I think you should blow it up and do it correctly.. What you do on the practice field determines how you do on the playing field.

    http://thelifestrategist.wordpress.com/2013/07/14/database-maintenance-and-management/



    Dame Luthas, ITILv3, MCSE Messaging 2013, MCSA, MCITP

    My Technical Blog: http://thelifestrategist.wordpress.com/

    Discipline is the Difference between Goals and Accomplishments..

    • Proposed as answer by Dame Luthas Friday, July 19, 2013 5:48 PM
    • Marked as answer by rush2ramki Saturday, July 20, 2013 4:05 PM
    Friday, July 19, 2013 5:48 PM
  • Thanks dame, so looks like you are finally saying moving the mailbox to new database and left the old DB / defrag the Old DB right

    http://thelifestrategist.wordpress.com/2013/07/14/database-maintenance-and-management/

    but the above link looks onlt cmd lets and not having any suggestion over on query


    Thanks 




    ramakrishnan

    Saturday, July 20, 2013 6:29 AM
  • How can I reclaim the whitespace?

    Naturally, after seeing the available whitespace in the database, the question that always ensues is – how can I reclaim the whitespace?

    Many assume the answer is to perform an offline defragmentation of the database using ESEUTIL. However, that's not our recommendation. When you perform an offline defragmentation you create an entirely brand new database and the operations performed to create this new database are not logged in transaction logs. The new database also has a new database signature, which means that you invalidate the database copies associated with this database.

    In the event that you do encounter a database that has significant whitespace and you don't expect that normal operations will reclaim it, our recommendation is:

    1. Create a new database and associated database copies.
    2. Move all mailboxes to the new database.
    3. Delete the original database and its associated database copies.

    The above steps has been taken and obtain the space. Thanks Mate


    ramakrishnan

    Saturday, July 20, 2013 4:05 PM