Create a Differential backup using SQLPS

107 Views Asked by Ryan Gillooly At 25 August 2015 at 15:41

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

There are 1 best solutions below

Mike Shepard On 25 August 2015 at 15:49 BEST ANSWER

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