Timeline for Log backup Job disable and enable during FULL backup -Sql Server 2008R2
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 4, 2021 at 14:50 | comment | added | Elvin Ahmadov | I'm not sure which type of backups will use DMA while migration, but if you'll have full backup before starting migrations testing and plus following T-Log backups, no matter DMA will take FULL backup with COPY_ONLY option or not, in case of disaster, you can restore your FULL+T-Log backups without any problem. | |
| Aug 3, 2021 at 15:23 | comment | added | pds | Thanks Elvin. I will be using DMA for migration but not sure it's using COPY_ONLY Backup or not. Even though If I use DMA then it will not hurt any Log chain or sequence, right? I am not intending to disable the TLog job but trying to avoid any side effect for Log chain but I am not going to change the Recovery Model as will be keeping FULL so it will be fine, right? | |
| Aug 3, 2021 at 14:39 | history | answered | Elvin Ahmadov | CC BY-SA 4.0 |