Creating a differential backup
This recipe will discuss how you can create a differential backup on your database.
We will use the
AdventureWorks2014 database for this recipe. We will create a differential compressed backup of the database to a timestamped
.bak file in the
C:\Backup folder. Feel free to use a database of your choice for this task.
The T-SQL syntax that will be generated by this PowerShell recipe will look like this:
BACKUP DATABASE [AdventureWorks2014] TO DISK = N'C:\Backup\AdventureWorks2014_Diff_20150314092409.bak' WITH DIFFERENTIAL , NOFORMAT, INIT, NAME = N'AdventureWorks2014 Diff Backup', NOSKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10, CHECKSUM
How to do it...
Let's list the steps required to create a differential ...