July 11, 2012 at 4:24 pm
Hi all,
Fully backed up a primary DB, and restored on secondary server from a full backup on the primary late this afternoon. However, we have 3rd party software that calls SQL to do a full backup every evening, so would it be ok to set up log shipping in the morning, or would any transactions that occurred between the 2 backups not be included in the first shipped log?
Cheers,
BLL
July 12, 2012 at 3:04 am
You will need to do the LS configuration in one day if you are doing daily full backups. If you cannot do this then I would suggest taking a differential backup one night instead, then you can restore the diff then continue with the logshipping configuration.
July 12, 2012 at 3:31 am
Full backups don't affect log backups. As long as you have a full to start LS, and all the logs since the full, you are OK.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply