Backups don''t work

  • I am just trying to setup some simple backups for my SQL data, using enterprise manager...and they won't work. It won't save my backup location...what am I doing wrong.

  • A little detail would be helpful .....         My car won't start, what's wrong with it ?

  • Okay well...I just set up a maintaence plan in EM and I click okay and close it...then view the properties and the backup location and the schedule are empty...I just don't understand.

  • You mean the schedule area of the Maint plan is blank ?

    In a maintenance plan, you have tabs for different options: Optimization, Integrity, Complete Backup and Transaction Log Backup. Each one of those has it's own schedule (and creates its own job you can see under "Management" > "SQL Agent" > "Jobs").

    Depending on which options you chose when you ran the wizard, you should have something in the schedule for those, but not the others. Is it possible you're getting confused about which area your looking in ?  Create a new maint plan to go through the excercise again and maybe that will shed some light ?

  • homebrew01 you rock. I figured it all out and hopefully it will run tonite.

    Thanks dude.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply