Log Backup

  • Hi,
    I have backup routine in place that runs in night and take full backup . Now I want to implement log backups too.
    I am not using maintenance plan , instead doing it with scripts. So I will have 2 jobs, 1- full backup, 2 - log backup that will run at 10min interval.

    My question is regarding consistency . e.g. log backup will run every 10min, this log backup job will execute even when full backup in progress "as both are independently schedule". in this scenario , do I need to take care of anything or MSSQL will take care of LSN or other related stuff ?

    Thanks

  • The log backups are separate  from fulls. They can both be scheduled together and SQL Server will sort out how they work. Just schedule them and as long as you don't have resources issues, you'll be fine.

  • The log backup can run at the same time as full - that's fine.  I would stagger the schedules if I were you, so that if the full backup starts on the hour, the log backup doesn't.  How long does your full backup take, by the way?  If your database has been in full recovery mode for a while and you're only just starting to do log backups, you should find that the time that the full backup takes will decrease.

    John

  • John Mitchell-245523 - Tuesday, February 7, 2017 7:15 AM

    The log backup can run at the same time as full - that's fine.

    John

    Steve Jones - SSC Editor - Tuesday, February 7, 2017 7:13 AM

    The log backups are separate  from fulls. They can both be scheduled together and SQL Server will sort out how they work. Just schedule them and as long as you don't have resources issues, you'll be fine.

    ...Assuming you're working on modern versions of SQL Server.  If you're running SQL 2000 or before, then no, they won't run together.  See Paul Randal's statement of this on ServerFault.

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • ThomasRushton - Tuesday, February 7, 2017 7:28 AM

    John Mitchell-245523 - Tuesday, February 7, 2017 7:15 AM

    The log backup can run at the same time as full - that's fine.

    John

    Steve Jones - SSC Editor - Tuesday, February 7, 2017 7:13 AM

    The log backups are separate  from fulls. They can both be scheduled together and SQL Server will sort out how they work. Just schedule them and as long as you don't have resources issues, you'll be fine.

    ...Assuming you're working on modern versions of SQL Server.  If you're running SQL 2000 or before, then no, they won't run together.  See Paul Randal's statement of this on ServerFault.

    Yes, I am using mssql 2012

  • This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply