Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.

Creating Multiple Backup Schedules with SQL 2000 - enterprise manager

Last post 04-24-2008 10:31 AM by Dan Baker. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 04-24-2008 10:31 AM

    • Dan Baker
    • Top 500 Contributor
    • Posts 19
    • Organization: Ursuline Academy
    • Products:  The Education Edge, The Raiser's Edge

    Creating Multiple Backup Schedules with SQL 2000 - enterprise manager

    Because you can not make multiple backup schedules within the BMC, I have found this to be frusturating, and would like to not use 3rd party backup utilities to do so - (simply so all my backups are in the same place, format, etc)

    You can open SQL Sercer Enterprise Manager:

    1) Expand up your server that contains your FE/EE DB

    2) Expand "Management"

    3) Click on Jobs

    4) Open up your BMC scheduled task - BMC: Scheduled backup (*yourdbname*)

    5) Go to the "Schedules" TAB

    6) Add a new schedule

    This will use the same compression and "days to keep" options that the BMC uses, therefor making the backups in the same location.  Offsite your backups like usual and your good to go.

    Filed under:
Page 1 of 1 (1 items)