SQL Server 無日誌檔案附加資料庫

CREATE DATABASE DBname
ON (FILENAME = 'D:\SalesData\DBname_data.mdf') 
FOR ATTACH_REBUILD_LOG ;
GO

　　簡單好用