Results 1 to 2 of 2

Thread: Database backup

  1. #1
    Join Date
    Mar 2002

    Unanswered: Database backup

    We have Sybase Central: Looking for a batch [.bat] file to make the database backup during the database is still running.

    Can someone help me?

  2. #2
    Join Date
    Mar 2001
    Lexington, KY
    Well, I'm not sure what you're trying to accomplish with "Sybase Central" and batch files, but remember that Sybase has a 'backup server' which you use to make backups.

    Ensure the backup server is running (sounds like you're on NT, go into services and start {your server}_backup if it isn't already running) and then run:
    DUMP DATABASE whateverdb TO "c:\wherever"
    If you have ISQL on the box you could run ISQL from the batch window which then issues the dump database command (you'll probably have to place it in a text file then tell isql to run it).


Posting Permissions

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