实现代码如下：
backup log dbName with NO_LOG;
backup log dbName with TRUNCATE_ONLY;
DBCC SHRINKDATABASE(dbName);
以上就是【收缩数据库日志文件的方法(仅适用于mssql2005)】的全部内容了,欢迎留言评论进行交流!
backup log dbName with NO_LOG;
backup log dbName with TRUNCATE_ONLY;
DBCC SHRINKDATABASE(dbName);