Creating a differential backup
This recipe will discuss how you can create a differential backup on your database.
Getting ready
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 ...
Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.