Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2004
    Posts
    76

    Thumbs up 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.

    Thanks :

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    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.

  3. #3
    Join Date
    Mar 2004
    Posts
    114
    If you only want a backup, don't maintenance plan. Just take a job with T-SQL step

    Code:
    BACKUP DATABASE mydb TO mydiskfile WITH INIT
    Take care of creating a disk drive before.

  4. #4
    Join Date
    Sep 2004
    Posts
    76
    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?

    Thanks R.Mall

  5. #5
    Join Date
    Mar 2004
    Posts
    114
    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.

  6. #6
    Join Date
    Sep 2004
    Posts
    76
    Thanks to you, I will try it.

    R.Mall

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •