I am almost embarrassed to ask but in all my years of MsSql anytime I needed to get to a point in time I'd restore backups and then all transactions up to my date I needed. However if 10 days ago I have a full backup, then have trans backups the next 4 days, then full backup, then trans backups up to current.
Could I take my backup from 10 days ago and apply all transactions and get to current, or do I need the backup prior to the transactions to be restored before transaction restores?
The reason for this question is I need to transmit data from about 50 locations to a central place and recreate the 50 databases at the central place, but I&: rather just ship the transactions backups over weekly?
Any better methods besides implementing full transaction shipping which is a juggernaut of a task have 50 locations dumping into 1 simultaneously.