BonuS
User STM
Data inscrierii: 27/Oct/2009
Mesaje: 50
Localitate: ~ItalY~
|
 Trimis: 28/10/2009 15:56 Titlul subiectului: Cum Faci backup Datebase to Disc |
 |
|
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. 
2. 
3. 
4. 
5. 
6.
7. 
8. 
9. [img]http://img402.imageshack.us/i/sqljob8up6.jpg/img]
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. |
|
