Backing up a Microsoft SQL 2005 database with the Database Maintenance Plan wizard

Article:TECH104792  |  Created: 2008-01-24  |  Updated: 2011-08-12  |  Article URL http://www.symantec.com/docs/TECH104792
Article Type
Technical Solution


Issue



Best practice calls for making regular backups of the data crucial to a Symantec Endpoint Protection environment. It is possible to schedule backups using built-in tools in Symantec Endpoint Protection Manager (SEPM).  Alternately, the Microsoft SQL Server Enterprise Manager provides a wizard to help set up a database maintenance plan. You can use the Database Maintenance Plan wizard to manage the database and to schedule automatic backups of the SEPM's Microsoft SQL database.


 


Solution




    Note: Sysadmin access rights are required to run the Database Maintenance Plan wizard.


     

    This article is intended to provide an example on how to run the Database Maintenance Plan wizard on a default Symantec Endpoint Protection Manager (SEPM) database. Although SEPM database is used in this example, the same steps can be applied to any SQL 2005 database. Please refer to the Microsoft SQL Server documentation for more details on how to maintain a Microsoft SQL Server database.


    To back up a Microsoft SQL database by using the Database Maintenance Plan wizard in the Microsoft (MS) SQL Server 2005 Management Studio

    1. On the Server running "MS SQL Server", click Start> All Programs> Microsoft SQL Server 2005> SQL Server Management Studio.
    2. Connect to the "SQL Server" and authenticate by providing your "user credentials."
    3. In the "Object Explorer" tab, expand the server name where "server name" is the name of the server on which the Symantec Endpoint Protection database is installed. Then expand the Management Folder.
    4. Right-click the Maintenance Plans folder, and then select the Maintenance Plan Wizard.




      Note: If an error occurs when trying to start the Maintenance Plan Wizard, make sure that the SQL Server Agent Service is started.



       
    5. On the "Welcome to the Database Maintenance Plan Wizard" screen, click Next.

      Click to enlarge

       
    6. On the "Select the Target Server" screen, type the <name> that you will call this plan. (Example: "SEP SQL DB Maintenance Plan").
    7. On the "Select the Target Server" screen, select the SQL server that will run the Maintenance plan. The default setting will most likely not need to be changed.
    8. On the "Select the Target Server" screen, provide the <User Credentials> to use to connect to the MS SQL server when the maintenance plan runs.
    9. On the "Select the Target Server" screen, click Next.

      Click to enlarge

       
    10. On the "Select Maintenance Tasks" screen, place a check next to the "Backup Database (Full)."
    11. On the "Select Maintenance Tasks" screen, click Next.

      Click to enlarge

       
    12. On the "Select Maintenance Tasks Order" screen, click Next.

      Click to enlarge

       
    13. On the "Define Back Up Database (Full) Task", click the database: <Select One or More> pull down box.

      Click to enlarge

       
    14. Place a check next to the "Symantec Endpoint Protection Database" (Default Name: SEM5).
    15. Click OK.

      Click to enlarge

       
    16. Click the Folder: text box and type the <directory name> where you want the DB to be backed up to (Example: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup).
    17. Place a check in the "Verify Backup Integrity" option.
    18. Click Next.

      Click to enlarge

       
    19. If you do not want the backup to occur on a scheduled frequency jump to Step 24.
    20. Click Change.

      Click to enlarge

       
    21. In the "New Job Schedule" screen, type a <name> for the schedule.

      Click to enlarge

       
    22. In the "Frequencies" section, select the options that corresponds to the "frequency", "days" and "times" that you want the backup to occur.
    23. Click OK.

      Click to enlarge

       
    24. Click Next.

      Click to enlarge

       
    25. Click Next.

      Click to enlarge

       
    26. Click Finish.

      Click to enlarge

       
    27. Click Close.



    To remove older, previous backups, create an additional maintenance plan:
    1. On the Server running MS SQL Server, click Start> All Programs> Microsoft SQL Server 2005> SQL Server Management Studio.
    2. Connect to the SQL Server and authenticate by providing your <user credentials>.
    3. In the "Object Explorer" tab, expand the server name where "server name" is the name of the server on which the Symantec Endpoint Protection database is installed. Then expand the Management Folder.
    4. Right-click the Maintenance Plans folder, and then select the Maintenance Plan Wizard.




      Note: If an error occurs when trying to start the Maintenance Plan Wizard, make sure that the SQL Server Agent Service is started.



       
    5. On the "Welcome to the Database Maintenance Plan Wizard" screen, click Next.

      Click to enlarge

       
    6. On the "Select the Target Server" screen, type the <name> that you will call this plan. (Example: "SEP SQL DB Maintenance Plan").
    7. On the "Select the Target Server" screen, select the SQL server that will run the Maintenance plan. The default setting will most likely not need to be changed.
    8. On the "Select the Target Server" screen, Provide the <User Credentials> to use to connect to the MS SQL server when the maintenance plan runs.
    9. On the "Select the Target Server" screen, Click Next.

      Click to enlarge

       
    10. On the "Select Maintenance Tasks" screen, place a check next to Clean Up History.
    11. Click Next.

      Click to enlarge

       
    12. Click Next.
    13. Verify that a check appears next to Backup and Restore History.
    14. Select a time frame that you want older data removed.
    15. Click Next.

      Click to enlarge

       
    16. If you do not want the Clean Up to occur on a scheduled frequency jump to Step 21.

       
    17. Click Change.
    18. In the "New Job Schedule" screen, type a <name> for the schedule.
    19. In the "Frequencies" section, select the options that corresponds to the "frequency", "days" and "times" that you want the backup to occur.
    20. Click OK.
    21. Click Next.
    22. Click Next.
    23. Click Finish.
    24. Click Close.




 




Legacy ID



2008042407391148


Article URL http://www.symantec.com/docs/TECH104792


Terms of use for this information are found in Legal Notices