Misconception about Database Backup

Does DATABASE Full Backup break the Log Chain Sequence Number (LSN)?
No; This is not TRUE. Initiating a full back up outside the schedule will not break the LSN, hence this will not impact your point in time restore of the database.
But this could impact your RTO if “Differential Backup” is a part of your backup strategy; this is because ad-hoc Full Backup will change the first LSN.

Here we can see that First_LSN changes with every Full back which impacts the RTO.
You cannot apply transaction log backup on the top of Copy-Only Backup
Incorrect – YOU CAN APPLY (*.TRN)

Can I initialize my Always-On Database Copy_Only Backup?
No, Database cannot initialize for Always-On with Copy_Only backups.
How the Log backup behaves on Asynchronous Replica?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s