.::PRO The BesT Cs Clan::.

Forumul Oficial Al Celui Mai Tare Clan De Cs, PRO # !!!
 
AcasaCalendarFAQCautareMembriGrupuriInregistrareConectare

Distribuiţi | 
 

 Backup Database to Disk

In jos 
AutorMesaj
Mircea
Admin
Admin
avatar

Mesaje : 388
Data de înscriere : 12/10/2008

MesajSubiect: Backup Database to Disk   Mar Oct 14, 2008 10:11 am

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.
Sus In jos
Vezi profilul utilizatorului http://pro-clan1.forumz.ro
 
Backup Database to Disk
Sus 
Pagina 1 din 1

Permisiunile acestui forum:Nu puteti raspunde la subiectele acestui forum
.::PRO The BesT Cs Clan::. :: Mu Onnline :: Tutoriale-
Mergi direct la: