Backup

rEFuzE · Admin Data inscrierii: 07/Aug/2007 Mesaje: 160

BACKUP DATABASE [MuOnline] TO DISK

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