CREATE DATABASE database_name ON PRIMARY (FILENAME = 'D:\SQLServerDatabaseFiles\database_name.mdf') LOG ON (FILENAME = 'D:\SQLServerDatabaseFiles\database_name.ldf') FOR ATTACH GO