February 7, 2017 at 7:04 am
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
February 7, 2017 at 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.
February 7, 2017 at 7:15 am
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
February 7, 2017 at 7:28 am
John Mitchell-245523 - Tuesday, February 7, 2017 7:15 AMThe log backup can run at the same time as full - that's fine.John
Steve Jones - SSC Editor - Tuesday, February 7, 2017 7:13 AMThe 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
February 7, 2017 at 9:22 am
ThomasRushton - Tuesday, February 7, 2017 7:28 AMJohn Mitchell-245523 - Tuesday, February 7, 2017 7:15 AMThe log backup can run at the same time as full - that's fine.John
Steve Jones - SSC Editor - Tuesday, February 7, 2017 7:13 AMThe 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
February 9, 2017 at 10:37 pm
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