Search code examples
sql-serverpowershellsqlps

Create a Differential backup using SQLPS

I have created a FULL database backup using the following: 

Backup-SQLDatabase -ServerInstance $sqlServer -Database $db.name -BackupFile $fullBackupFilePath -BackupAction Database

I cannot find anywhere specifying the correct -BackupAction for a Differential Backup

Solution

  • This page mentions that in SQL 2012 and above there is an -Incremental switch for doing differential backups.