SQL Server 2012 Database Restore method

Use master
RESTORE DATABASE wss_content from DISK = N ' D:\bak\contentbak.bak '
With REPLACE, NORECOVERY
, MOVE ' wss_content ' to N ' D:\bak3\WSS_Content.mdf '
, MOVE ' Wss_content_log ' to N ' D:\bak3\WSS_Content_log.ldf '

The move ' WSS_Content ' is the name of the previous backup, that is, the database file name of the previous backup is called WSS_Content, then this should be called WSS_Content, the logical name.

Assuming that the database has been "being restored" after the restore, you need to execute the following command to change its state.

Restore Database wss_content with recovery

SQL Server 2012 Database Restore method