Remtoe SQL Server backup on local server using SSIS

  • I am trying to create a package that would take remote sql server backup on my local server. But all efforts went in no-result. Does anyone has any idea to create the same package ?

    Thanks in advance...

  • Do u have permissions to take backup on the other side?

  • Yes I have full permission.

  • You might want to take a look at this tool: BAK 2 Local

  • pl. provide more details what exactly are you doing? And how you are setting up backup?

    Usually there should not be any issue you can store backup locally as well as on other location/server too.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

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

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