gexy Posted July 13, 2011 Share Posted July 13, 2011 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. Link to comment Share on other sites More sharing options...
Recommended Posts