Backup Database to Disk

[gexy]

D:\MuServer\db backs\MuOnline.bak' WITH INIT , NOUNLOAD , NAME = N'MuOnline backup', NOSKIP , STATS = 10, NOFORMAT Above is the Script which will backup your database

now go to Start>All programs>Microsoft SQL Server>Enterprise Manager

Follow the image below.

Note: ON the Script above(the one has red color) it must exist or else the job will gives you a error.

1. http://img260.imageshack.us/img260/6180/sqljob1qk1.jpg

2. http://img183.imageshack.us/img183/9038/sqljob2ul8.jpg

3. http://img260.imageshack.us/img260/9082/sqljob3ik1.jpg

4. http://img260.imageshack.us/img260/3343/sqljob4ap5.jpg

5. http://img183.imageshack.us/img183/3746/sqljob5fa8.jpg

6. http://img183.imageshack.us/img183/5959/sqljob6du1.jpg

7. http://img183.imageshack.us/img183/9548/sqljob7my4.jpg

8. http://img142.imageshack.us/img142/315/sqljob8up6.jpg

Ok, cand ati terminat, trebuie sa dati clik dreapta pe Job si selectati Start Job

The job continue to occure depends on the Occure Time you set for that Job.