SQL Server/T-SQL Tutorial/Database/RESTORE DATABASE
RESTORE DATABASE WITH FILE = 2, RECOVERY
RESTORE DATABASE NWCopy
FROM NWCopyBK_1
WITH FILE = 2, RECOVERY
GO
RESTORE DATABASE WITH NORECOVERY
RESTORE DATABASE NWCopy
FROM NWCopyBK_1
WITH NORECOVERY
GO