Options

Back Ups are Blocking.

Hello, 
We are backing the log for every 15 minutes, but at 1 point of the day we are fully backing up the DB, Is there a way to  stop backing up the log when the fully back up is beeing done?

Thanks.
Tagged:

Answers

  • Options
    Dan_JDan_J Posts: 450 Silver 2
    edited December 1, 2022 11:48AM
    Hi @mvallaro

    Thanks for reaching out to us regarding this.

    There isn't a way to block the log backups from taking place while the full backup is in progress, however to work around this, it might be worth scheduling the log backups to end shortly before the full backup is due to start, and start after you know the full backup will have definitely finished.

    I hope that helps! 
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • Options
    WasionWasion Posts: 1 New member
    Yes, it is possible to stop backing up the log when a full database backup is being done. One way to achieve this is to use a script or a program that checks for the presence of a full backup and temporarily suspends the log backup process during that time. The script can be triggered to run at the same time as the full backup, and then resume the log backup process once the full backup is complete.

    Additionally, you can check if your database management system (DBMS) has a built-in feature for this. Many DBMSs, such as SQL Server, have the option to suspend and resume log backups geometry dash lite as part of the backup process. For example, in SQL Server you can use the "WITH NO_LOG" option in the backup command to stop the log backup while the full database backup is in progress.
Sign In or Register to comment.