• aledavsanort - Tuesday, January 23, 2018 6:30 AM

    So.. if i make a full database backup in my primary it will allow me to make transaction logs in the secondaries? if so.. i can apply the transaction logs to the primary? 

    It creates a log chain, but it doesn't explain how the log chain works, what happens if i want to restore the primary database to a point in time? i got the full backup of the main database, how would i use these log chain backups made in the secondaries, will the primary allow the use of transaction logs made from another database engine to be used in it?

    Yes and yes. You can take full backups on the primary, and transaction log backups on the secondary, and combine those backups if you need to do a point in time restore (provided, of course, that you can get hold of all of those backups when you need them). HOWEVER, unless this has changed recently, you won't be able to use the GUI to do a nice, simple restore for you, you'll have to script it.

    Whether it's a good strategy for you remains to be seen. In the even of a disaster, will you know where all of your backups are and have easy access to them all? Perhaps you could write them all to the same fileshare, ensuring that the files are date-stamped?

    It's really worthwhile setting up a Dev cluster and testing this scenario yourself, because it seems easier when you're actually doing it.