摘要:
1.清除数据库日志。DUMP TRANSACTION ASPState WITH NO_LOGBACKUP LOG ASPState WITH NO_LOG DBCC SHRINKDATABASE(ASPState) 2.使用sp_attach_db加载数据库 EXEC sp_attach_db @dbname = N'OA', @filename1 = N'D:\Database\OA.Data.mdf', @filename2 = N'D:\Database\OA.Log.ldf';3.编辑bat文件执行语句SQLCMD -S(... 阅读全文