SQL 附加无日志数据库

CREATE DATABASE 数据库名字
ON (FILENAME = 'D:\SalesData\archdat1.mdf')
FOR ATTACH_REBUILD_LOG ;
GO