BACKUP YOUR DATABASE MuOnline

Hi to all MU Server admin, this guide will help you backup your database using sql job agent.

Code:
BACKUP DATABASE [MuOnline] TO DISK = N'
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.https://2img.net/r/ihimizer/img260/6180/sqljob1qk1.jpg
2.https://2img.net/r/ihimizer/img183/9038/sqljob2ul8.jpg
3.https://2img.net/r/ihimizer/img260/9082/sqljob3ik1.jpg
4.https://2img.net/r/ihimizer/img260/3343/sqljob4ap5.jpg
5.https://2img.net/r/ihimizer/img183/3746/sqljob5fa8.jpg
6.https://2img.net/r/ihimizer/img183/5959/sqljob6du1.jpg
7.https://2img.net/r/ihimizer/img183/9548/sqljob7my4.jpg
8.https://2img.net/r/ihimizer/img142/315/sqljob8up6.jpg

Ok, when you finish, you may Right Click the Job and select Start Job
The job continue to occure depends on the Occure Time you set for that Job.