February 14, 2017 at 12:19 am
Restored last copy only log backup after taking 4 consecutive Copy Only Logs and observed that I can restore the last log even if i delete the other log file(individual logs can be restored) ,seems like the log files are acting like a differential backup?
I was expecting only changes during that particular log backup not all.
Is there any relation between differential backup and copy only logs ?
February 14, 2017 at 2:22 am
No, there isn't.
A copy-only log backup doesn't truncate the transaction log, so the last of the copy-only log backups contained all the log records since the last non-copy only log backup.
Do note that copy-only log backups aren't something you'll be taking for long periods, because they don't truncate the transaction log and so your transaction log will grow until you start taking normal log backups again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 14, 2017 at 5:55 am
GilaMonster - Tuesday, February 14, 2017 2:22 AMNo, there isn't.A copy-only log backup doesn't truncate the transaction log, so the last of the copy-only log backups contained all the log records since the last non-copy only log backup.
Do note that copy-only log backups aren't something you'll be taking for long periods, because they don't truncate the transaction log and so your transaction log will grow until you start taking normal log backups again.
Thanks Gail.
Now I understood why I got to see all previous records. Yes,will use normal log backup as part of backup plan.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply