How to Set the Maintenance Schedule for a Database

Microsoft Exchange Server 2007 will reach end of support on April 11, 2017. To stay supported, you will need to upgrade. For more information, see Resources to help you upgrade your Office 2007 servers and clients.

 

Applies to: Exchange Server 2007, Exchange Server 2007 SP1, Exchange Server 2007 SP2, Exchange Server 2007 SP3

This topic explains how to use the Exchange Management Console or the Exchange Management Shell to set the maintenance schedule for a mailbox database or public folder database. To ensure that your public folder and mailbox databases continue to operate efficiently, we recommend that you perform daily database maintenance. Microsoft Exchange Server 2007 Mailbox servers automate the tasks based on the schedule that you specify. For more information about the tasks that are performed during database maintenance, see Maintaining Mailbox Databases and Public Folder Databases.

Before You Begin

To perform this procedure, the account you use must be delegated the following:

  • Exchange Server Administrator and local Administrators group for the target server

For more information about permissions, delegating roles, and the rights that are required to administer Exchange 2007, see Permission Considerations.

Procedure

To use Exchange Management Console to set the maintenance schedule for a database

  1. Start the Exchange Management Console.

  2. In the console tree, expand Server Configuration, and then click Mailbox.

  3. In the result pane, click the Mailbox server on which the database resides.

  4. In the work pane, click the mailbox or public folder database for which you want to set the maintenance schedule.

  5. In the action pane, under the name of the database, click Properties. The <Database Name> Properties dialog box appears.

    General Tab of the Database Properties

  6. On the General tab, in the Maintenance Schedule list, select a predefined schedule or to create a customized schedule, select Use Custom Schedule, and then click Customize.

    Note

    We recommend that you perform daily maintenance at a time when there is little activity on the database.

  7. Click OK to save your changes.

To use the Exchange Management Shell to set the maintenance schedule for a database

  • To set the database schedule for the mailbox database named MailboxDatabase1 on Server01 to run between 02:00 and 03:00 on Wednesdays and Sundays, run the following command.

    Set-MailboxDatabase -Identity "Server01\MailboxDatabase1" -MaintenanceSchedule "Sun.2:00-Sun.3:00","Wed.2:00-Wed.3:00"
    

For detailed syntax and parameter information, see Set-MailboxDatabase.

For More Information

For more information about mailbox databases, see Managing Mailbox Databases.

For more information about public folder databases, see Managing Public Folders.

For more information about the tasks that are performed during database maintenance, see Maintaining Mailbox Databases and Public Folder Databases.