copy job

  • i need to copy the backup file from one server to another server ?

    can any one send me the script to achieve this

  • Don't need a script for this - you can copy the .bak file as easily as any other file.

    or

    Do you mean that you want to backup a database to a different server?

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • This is as simple as using Windows to copy and paste the file. If you need it automated, you could write a batch file to copy one or all files from a given directory to another server. My suggestion is to do this using the operating system, not SQL.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply