Restore Database with Recovery and No Recovery

–Restore Database With NORECOVERY  & With Recovery

USE [master]
RESTORE DATABASE [Test]
FROM  DISK = N’C:FullBackupsBackupDatabase.bak’
WITH  FILE = 1,
NORECOVERY,
NOUNLOAD,
STATS = 5

RESTORE DATABASE [Test]
FROM  DISK = N’C:FullBackupsBackupDatabase.bak’
WITH  FILE = 7,
NORECOVERY,
NOUNLOAD,
STATS = 5

RESTORE LOG [BackupDatabase]
FROM  DISK = N’C:FullBackupsBackupDatabase.bak’
WITH  FILE = 8,
NOUNLOAD,
STATS = 5

GO