Sunday, January 22, 2012

Schedule Daily backup of database in MS-SQL Server 2008

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.
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.