SQL-SERVER 2008 FULL RECOVERY with DIFFERENTIAL

1. Create a new blank database

CREATE DATABASE newDB1

GO

ALTER DATABASE newDB1 SET OFFLINE WITH

ROLLBACK IMMEDIATE
GO

RESTORE DATABASE IRT2

FROM DISK = 'C:\jimnet_backup\SQL_BU\IRT\IRT_backup_2016_02_02_050001_4827264.bak'

WITH REPLACE, NORECOVERY;

GO

RESTORE DATABASE IRT2

FROM DISK = 'C:\jimnet_backup\SQL_BU\IRT\IRT_backup_2016_02_02_204501_1235685.trn'

WITH RECOVERY;

GO

Must STrat with first differential file and all others up to that point in time.

Exited out

opened backup