H&S Heilig und Schubert Software AG
How to schedule
SQL Maintenance Plan
for MS SQL Server 2005
All Rights Reserved. Including all rights concerning reproduction, copying or any other use or transmission of this document and its contents or parts of it. No part of this publication may, no matter in what form, be reproduced without written permission by H&S Heilig und Schubert Software AG, passed on to third parties, edited by electronic retrieval systems, copied, distributed or used for public presentations. H&S Heilig und Schubert Software AG reserves the right to change and update the content at any time. All data shown on screenshots is solely for demonstration purposes of the software. H&S Heilig und Schubert is not responsible for this content.
Trade Mark H&S: PAM-STORAGE ®
Microsoft ®, Microsoft Windows NT ® and the names of other Microsoft Products are registered trademarks of Microsoft Corporation.
Document
Management
beyond imitationWe recommend to schedule daily maintenance plan in SQL for the exchange@PAM database. In this way the database and log files will be backed up and shrunk down.
To schedule the maintenance plan for exchange@PAM database:
1. Run the Microsoft SQL Server Enterprise Manager from Start / Programs / Microsoft SQL server / SQL Server Management Studio.
2. Expand the Microsoft SQL Servers node down to the maintenance plan, e.g. VMXDEMO (SQL Server) / Management / Maintenance Plan.
3. Right-click the Maintenance Plan and from the context menu select Maintenance Plan Wizard to open it. Wizard window opens.
4. Enter the name for your maintenance plan (e.g. pam) and click the Change button to schedule it.
5. The Job Schedule Properties window opens:
In the Schedule type down-drop box select Recurring and check Enabled text box. In the Frequency section set it to run daily (Occurs Daily; Recurs every 1 day(s)). In the Daily Frequency section set the maintenance time in the Occurs once at text box. In the Duration section check the No end date radio button.
Document
Management
beyond imitation6. In the Maintenance Plan Wizard window click Next. In the following window make sure to select these maintenance tasks:
Shrink database
Clean Up History
Back Up Database (Full)
Document
Management
beyond imitationDocument
Management
beyond imitationNOTE: Bear in mind that each backup file requires as much space as the database itself.
Document
Management
beyond imitation10. Configure transaction log backup: Click the down arrow in the Database(s) text box. Check These databases radio button and select your exchange@PAM database. Click OK, then Next.
Document
