0

I am planning to test the Sql server migration of Production databases but i am thinking to stop TLog Backup job during Backup and Restore as I don't need TLog backup and my Backup and Restore process might be done by that time. Is it hurt anything like Log sequence or breaking log chain or is it safe to disable (stop) and enable (Turn ON) during Migration process?

Sql server: 2008R2 Recovery Model: FULL

Thank You

Improve this question

1 Answer 1

Reset to default
0

If you're just testing migration, no need to stop Transaction Log backups. Maybe something will happen during your testing period, and you'll lose data between this period of time.

If you'll disable T-Log backups without changing Recovery Mode to Simple, you will not brake the T-Log backup chain. After enabling them again, new T-Log will resume the same backup chain.

Improve this answer
2
  • 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?
    – pds
    Commented Aug 3, 2021 at 15:23
  • 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.
    – Elvin Ahmadov
    Commented Aug 4, 2021 at 14:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.