USE master;

/*Create a dummy database*/
CREATE DATABASE DiffRestoreTest

/*We simple now*/
ALTER DATABASE DiffRestoreTest SET RECOVERY SIMPLE

/*Context is everything*/
USE DiffRestoreTest

/*If nothing changes, do we even need a diff backup?*/
CREATE TABLE dbo.t1 (Id INT)

/*Take a full backup, dummy*/
BACKUP DATABASE DiffRestoreTest
TO DISK = 'F:BackupDRT_FULL.bak'
WITH INIT, FORMAT, COMPRESSION

/*Make a change*/
INSERT dbo.t1 (Id )
VALUES ( 1 )

/*Take a differential backup*/
BACKUP DATABASE DiffRestoreTest
TO DISK = 'F:BackupDRT_DIFF_1.bak'
WITH INIT, FORMAT, COMPRESSION, DIFFERENTIAL

/*Make another change*/
INSERT dbo.t1 (Id )
VALUES ( 2 )

/*Take another diff backup*/
BACKUP DATABASE DiffRestoreTest
TO DISK = 'F:BackupDRT_DIFF_2.bak'
WITH INIT, FORMAT, COMPRESSION

/*Make another change*/
INSERT dbo.t1 (Id )
VALUES ( 3 )

/*Take another diff backup*/
BACKUP DATABASE DiffRestoreTest
TO DISK = 'F:BackupDRT_DIFF_3.bak'
WITH INIT, FORMAT, COMPRESSION

/*Exit stage left*/
USE master

/*Restore the full backup*/
RESTORE DATABASE DiffRestoreTest
FROM DISK = 'F:BackupDRT_FULL.bak'
WITH REPLACE, STANDBY = 'F:BackupDRT_STANDBY.tuf'

/*Square one*/
RESTORE DATABASE DiffRestoreTest
FROM DISK = 'F:BackupDRT_DIFF_1.bak'
WITH STANDBY = 'F:BackupDRT_STANDBY.tuf'

/*Square 2*/
RESTORE DATABASE DiffRestoreTest
FROM DISK = 'F:BackupDRT_DIFF_2.bak'
WITH STANDBY = 'F:BackupDRT_STANDBY.tuf'

/*Square 3*/
RESTORE DATABASE DiffRestoreTest
FROM DISK = 'F:BackupDRT_DIFF_3.bak'
WITH STANDBY = 'F:BackupDRT_STANDBY.tuf'

/*Restore the full backup*/
RESTORE DATABASE DiffRestoreTest
FROM DISK = 'F:BackupDRT_FULL.bak'
WITH REPLACE, STANDBY = 'F:BackupDRT_STANDBY.tuf'

/*What happens if I try to jump the restores?*/
RESTORE DATABASE DiffRestoreTest
FROM DISK = 'F:BackupDRT_DIFF_3.bak'
WITH STANDBY = 'F:BackupDRT_STANDBY.tuf'

SELECT *
FROM DiffRestoreTest.dbo.t1 AS t

/*Bring'er online, lad*/
RESTORE DATABASE DiffRestoreTest WITH RECOVERY

DROP DATABASE DiffRestoreTest