ALTER DATABASE recovery_test_2 SET EMERGENCY;
ALTER DATABASE recovery_test_2 SET SINGLE_USER;

DBCC CHECKDB (recovery_test_2, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS;

USE [master]
  RESTORE DATABASE [database_name] FROM  DISK = N'D:database_name.bak' WITH  FILE = 1,
  MOVE N'database_name' TO N'D:MSSQLMSSQL12.MSSQLSERVERMSSQLDATAdatabase_name.mdf',
  MOVE N'database_name_index' TO N'D:MSSQLMSSQL12.MSSQLSERVERMSSQLDATAdatabase_name_index.ndf',
  MOVE N'database_name_log' TO N'D:MSSQLMSSQL12.MSSQLSERVERMSSQLDATAdatabase_name_log.ldf',
  NOUNLOAD,
  STATS = 5

  GO

USE [master]

RESTORE DATABASE [database_name] FROM  DISK = N'D:database_name.bak'

WITH  REPLACE,

MOVE N'database_name' TO N'D:~DATAdatabase_name.mdf',

MOVE N'database_name_index' TO N'D:~DATAdatabase_name_index.ndf',

MOVE N'database_name_log' TO N'D:~DATAdatabase_name_log.ldf',

GO

RESTORE DATABASE AdventureWorks FROM DISK = 'C:AdventureWorks.BAK'
WITH NORECOVERY
GO
RESTORE LOG AdventureWorks FROM DISK = 'C:AdventureWorks.TRN'
WITH RECOVERY
GO