Tech Paper - Create a Maintenance Plan to Back Up the Database

Version 2

    Deploying the ArcFM Solution on SQL Server White Paper

     

    It is important to create a maintenance plan to back up the database. The following step-by-step instructions guide you through the process.

    1. Open SQL Server Management Studio, expand the Management node, and then expand the Management Plans node.
    2. Right-click Maintenance Plans, click Maintenance Plan Wizard, and then type an appropriate name for this application database backup plan.

    MaintenancePlanWizard.png

    1. Click Separate schedules for each task, because you will later select both full and transaction log backups. Click Next.

    SelectPlanProperties.png

    1. On the Select Maintenance Tasks dialog box, select Clean Up History, Back Up Database (Full), Back Up Database (Transaction Log), and Maintenance Cleanup Task. Click Next twice.

    SelectMaintenanceTasks.png

    1. As you complete the Maintenance Plan Wizard, you should select options based on the needs of your organization. The following figures show examples of options you may want to select.
        • On the Define History Cleanup Task dialog box, select the historical data you want to delete and the schedule. Click Next.

    DefineHistoryCleanup.png

        • On the Define Back Up Database (Full) Task dialog box, click on These databases, and select the user database in the Database(s) box. Click OK.
        • On the Job Schedule Properties dialog box, select the frequency and duration of full backups. Click OK.

    JobScheduleProperties.png

        • On the Define Back Up Database (Full) Task dialog box, specify information about the full backup. Click Next.

    DefineBackupDatabase.png

        • On the Job Schedule Properties dialog box, select the frequency and duration of transaction log backups. Click OK.
        • On the Define Back Up Database (Transaction Log) Task dialog box, configure the transaction log backup. Click Next.

    DefineBackupDatabase2.png

        • On the Define Maintenance Cleanup Task dialog box, configure the cleanup tasks. Click Next.

    DefineMaintenanceCleanup.png

        • On the Select Report Options dialog box, select whether to write the report to text file or send the report through email. Click Next.
    1. Review your selections and click Finish.