"log shipping" by hand - SQl 2008 R2

  • I've been doing some research online and in the forum, but it's difficult to find the right key words to find what I'm looking for. Here is the issue:

    I'm getting sql backups and translogs from a 3rd-party vendor. We have no trusts between us, and so, they are just providing us one nightly full backup and trans log backups every 15 minutes through our sftp site.

    I'm needing to automate the restoration of these backups and translogs in a clean fashion.

    I have written my own ssis package already to do this task, but I'm not happy with the solution. There is a lot of logic that needs to be developed that I haven't done yet -- such as when the time of the full backup is not in my defined schedule; or when the full backup is restored late, then I still have other logs that could be laying around unapplied from the previous LSN.

    It seems like I couldn't have been the first person to have to do this. Am I re-inventing the wheel unnecessarily? I can continue to go down this road of applying a lot more logic to my package, but before I do I need to make sure I'm not wasting my time when there is already a solution available.

    I am aware, of course, of log shipping, but I didn't think that this can work between two disconnected servers in completely different networks.

    Thanks in advance, for your input and feedback.

  • I did not see that in all my google searches. Very good find. Thanks. I am going to try it.

  • citrowske (6/3/2015)


    they are just providing us one nightly full backup and trans log backups every 15 minutes through our sftp site.

    It doesn't sound to me like you need any type of transaction log shipping. Just do a download of the full and log backups and restore them as you would any other database.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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