-- Part 01
-- Check backup information
RESTORE FILELISTONLY
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_FULL.bak'
-- Restore Database with FULL Backup
RESTORE DATABASE AdventureWorksR2
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_FULL.bak'
WITH NORECOVERY
-- Part 02
RESTORE FILELISTONLY
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_DIFF.bak'
-- Restore Database with Differential Backup
RESTORE DATABASE AdventureWorksR2
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_DIFF.bak'
WITH NORECOVERY
-- Part 03
RESTORE FILELISTONLY
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_LOG_01.Log'
-- Restore Database with Log Backup
RESTORE DATABASE AdventureWorksR2
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_LOG_01.log'
WITH NORECOVERY
RESTORE DATABASE AdventureWorksR2
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_LOG_02.log'
WITH NORECOVERY
-- Final log with Recovery
RESTORE DATABASE AdventureWorksR2
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_LOG_03.log'
WITH RECOVERY