Restore MDF file to New Database

Execute below script to restore any MDF and LDF files to new Database.

USE [master]

GO

CREATE DATABASE DemoDB ON

( FILENAME = N'I:\MSSQL\DATA\DemoDB.mdf' ),

( FILENAME = N'K:\MSSQL\Logs\DemoDB_log.ldf' )

FOR ATTACH ;

GO