Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    4

    Unanswered: Running Transac SQL in Command Line

    Hi all

    I currently have a problem where I need to create a backup from MSSQL, via a command line, ideally from a batch script. This is on a PC. Each machine has SQL Server 2000 on.

    I just need to know the code that dos will tell it to run the sql statement. Ideally the command will also give the directory to place the backup.

    Regards MiloJ

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Funny that you should ask! There is a KB article just for you, #241937 that describes in detail just what you want.

    -PatP

  3. #3
    Join Date
    Apr 2004
    Posts
    4
    Pat, that's perfect you are 100% on the money, much obliged

Posting Permissions

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