SQL Server/T-SQL Tutorial/Database/RESTORE DATABASE
RESTORE DATABASE WITH FILE = 2, RECOVERY
<source lang="sql">
RESTORE DATABASE NWCopy FROM NWCopyBK_1 WITH FILE = 2, RECOVERY GO</source>
RESTORE DATABASE WITH NORECOVERY
<source lang="sql">
RESTORE DATABASE NWCopy FROM NWCopyBK_1 WITH NORECOVERY GO</source>