June 3, 2015 at 8:29 am
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.
June 4, 2015 at 1:29 am
June 4, 2015 at 7:02 am
I did not see that in all my google searches. Very good find. Thanks. I am going to try it.
June 4, 2015 at 8:41 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply