1. Open Management Studio.
2. Under "Mangement" select Maintenance Plans.
3. Right click and choose New Plan (it will ask for name).
4. Double click on Subplan_1 and change it to your name.
5. Drag from toolbox "Back Up Database Task" control.
6. Right click on it and choose Edit.
7. Choose Backup Type, Databases and change more fields.
8.OK
9. Click on Job Schedule (in end of row) and set backup date/time.
10. Save plan.
11. Under "Mangement" right click on your job and choose "Execute" for validation.
Enjoy!
Sunday, January 22, 2012
Thursday, January 19, 2012
Wednesday, January 18, 2012
Subscribe to:
Posts (Atom)