Post reply

DTS Package

  • November 29, 2007 at 12:32 pm

    #184470

    How do I, create a DTS package to backup a database on Server A, copy the file to Server B and restore the database on Server B?

    Thanks in advance.

  • November 29, 2007 at 1:08 pm

    #755655

    Please clarify which SQL Server version you're working with - 2000 or 2005. My suggestion would be different for each.

    Greg

    Greg

  • November 30, 2007 at 6:13 pm

    #756192

    Thanks Greg.

    I managed to create the DTS package.

  • December 1, 2007 at 11:53 am

    #756247

    You need to create a connection on Server A, then perform the backup using this connection.

    An ActiveX task is needed to perform the copy. The FileSystemObject in VBScript is probably the easiest way to accomplish this. You can find examples around, here's one

    http://www.sqldts.com/292.aspx

    Then you need a connection on Server B to execute the restore with. When you do the copy, I'd copy to the same file name on Server B everyeim, which makes this easier.

  • December 3, 2007 at 1:20 pm

    #756652

    Thanks Steve.

    I did not use an ActiveX Script, however, based on the example in the link that you specified, I will now do so.

    Thanks again.

Viewing 5 posts - 1 through 4 (of 4 total)

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