how the copy only backup works without breaking lsn what is internal machanisim ?

Question

Dear Folks,

how the copy only backup works without breaking ls what is internal mechanism ?

does it use any algorithm.

I checked in google, didn't find it.

Thanks,
Vijay

Answer 1

Hi @Vijay Reddy ,

A copy-only backup is a SQL Server backup that is independent of the sequence of convential SQL Server backups. It does not disturb the original backup workflow, but just create a copy of the original database independently.
The copy_only will be a stand alone full backup
https://dba.stackexchange.com/questions/45876/difference-between-full-backup-and-copy-only-full-backup#:~:text=When%20you%20have%20a%20full%20backup%20and%20a,you%20take%20will%20be%20the%20latest%20full%20backup.

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

A COPY_ONLY of a database has no special relation to LSN. COPY_ONLY for BACKUP DATABASE matters with differential backups. A normal BACKUP DATABASE clears the differential bitmap, but a COPY_ONLY backup does not.

There is also a COPY_ONLY for BACKUP LOG, I believe. That command simply skips truncating the transaction log, so that next regular backup will still include that part.