incremental full backup

Backup Copy Only Sql Server

Backup Copy Only Sql Server is a new feature in Sql Server 2016 which allows you to create a copy of a backup without including the data files. This can be useful if you need to create a backup for a different server or if you need to create a backup of a backup.

To create a backup copy only, you can use the Backup-SqlDatabase cmdlet. The cmdlet has the -CopyOnly parameter which you can use to create the backup …