Automating Sql(2008R2) backup/Restoration process

[nav mac]

Hello All,



I have 6 db's to be backed up and restored every week and i want to automate them,can anyone help me out how do I acheive this? Please guys I have deadline tomorrow.

[ck9663]

1. Create an SP that backup your data.
2. Create a job and set it to run every week.
3. Test the job for your first run.


Good Luck!!!


~~ CK