Post reply

Network back of specific tables

  • April 9, 2002 at 10:29 am

    #58057

    I am running SQL7 and would like to backup to another server for reporting purposes in an automated way. Can this be done if the tow servers are on different domains and could it be done using the bcp utility?

    Many thanks

  • April 9, 2002 at 10:55 am

    #426887

    Yes you can use bcp to export and then import on the remote server as long as you have a SQL Login or you move the file to the other server and execute the bcp there. But you can do this thru export in a DTS package if you use a SQL Login as opposed to NT Login.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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