[T-SQL] 使用.mdf 和 .ldf 建立 DB

 CREATE DATABASE TestDB 
    ON (FILENAME = 'D:\04_sample_code\MacroWell_LibWebSample\App_Data\TestDB.mdf'), 
    (FILENAME = 'D:\04_sample_code\MacroWell_LibWebSample\App_Data\TestDB_log.ldf') 
    FOR ATTACH;

參考連結

http://msdn.microsoft.com/zh-tw/library/ms190209.aspx