I'm using third party tool for making schedule database backups. I need to make one additional full backup. Should it be affected on the scheduled backups? If yes, is there any solution?
SQL Server Full Database Backup Guide
backupsql server
Related Solutions
As you can see in this table, there is no conflict between Full backup and Log backup. They can occur at same time, and, when log backup completes, log will not be cleaned until full backup (or diff backup) completes.
Not all administrative tasks are allowed to run concurrently. In the table below, a black circle indicates two operations that cannot run in a database at the same time.
References:
Taking a full backup will invalidate the subsequent differential backups, but it won't break the log chain. So you'd restore with your last full backup taken by the tool - and then all the subsequent log backups. Not ideal, but....
Can you take your full backup just before the tool takes its full backup?
Best Answer
The short answer is yes.
As usual, after full backup follows differential backups, that completely depend on the last full backup. It means that if the database failure occurs there will be no chance to apply scheduled differential backups because they will be with another LSN.
The solution is to use COPY_ONLY option.