RE: "log shipping" by hand - SQl 2008 R2

SSC Guru

Points: 1003861

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

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)