In addition to what Jacob has mentioned their is one more important point I would like to mention and that is, the multiple instances are for "abstracting". Example 1: Consider a scenario where a company have only one SQL box (this really happens in ...

well said Abi, this is the correct approach. Make sure that you don't forget to use `WITH NORECOVERY` clause, WITH NORECOVERY clause will allow you to restore another log backup and once you done with the applying all the transaction log say `RESTORE DATAB...