SQL Server Database Backup policy, why the first week of running failed

General production Library, using

Backup LOG every 10 minutes, backup diff every day, backup full policy weekly.

There are offsite backups at the same time. Offsite backups Use the Cmdshell stored procedure of SQL Server itself to invoke system commands.

After a backup policy is established for the new database, the log is often started to be backed up first.

At this point, if there is no full backup before the new library, the log backup and the diff backup fail. The diff and log backups all depend on the full backup, and a new library does not have a full backup.

So the first week of the policy run will fail.

To avoid this problem, run the full backup manually.

New library, if not backed up, such as.

SQL Server Database Backup policy, why the first week of running failed