March 28, 2011 at 10:39 pm
Noob question in regards to Log Shipping.
Being as the file copy job is set to kick off every 15 minutes, is it safe to assume that it's just copying the DB Changes (Deltas) not the entire DB?
If it is doing the whole thing, is it possible to set log shipping to only copy up the Deltas? Perhaps in setting up another job?
LS is sending it's info to a DR site, across the pond. I don't have dedicated bandwidth between the two, so would like to stream line things into size-able, burst-able chunks.
Thought and Opinions?
March 29, 2011 at 12:03 am
You might want to read up on log backups, so that you understand what they are.
Not deltas exactly, lists of operations that have occurred in the DB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply