var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Shedule Job and automatic backup
Thanks to every participants, I am oracle dba and rightnow looking for some tips which are avaialble in Oracle in MSSQL Server 2000.
1. How I can schedule job in MSSQL Server 2000.
2. How I can schedule database backup for no. of co's.
1. In Enterprise manager click -> Management --> Sql Server Agent --> jobs
right click say new job and u get a wizard to configure a new job.
2. For taking backups configure a database maintainance plan.
If you only want a backup, don't maintenance plan. Just take a job with T-SQL step
Take care of creating a disk drive before.
BACKUP DATABASE mydb TO mydiskfile WITH INIT
Thanks to every participants. I specialy thanks to kuzco.
Backup database mydb to mydiskfile with init.
This is ISQL command, How I can make scheduled backup which one automatically run at particular time and for more than 5 co's.
or how I can make batch file for windows 2000 advanced server box.
Is there any way?
You want to schedule under windows ?
If I understand what you want, make a cmd file calling the osql.exe or isql.exe command line tool. See BOL for detail.
Thanks to you, I will try it.