SQL 设置不产生日志的ALTER DATABASE [pubs] SET RECOVERY SIMPLE即可,ALTER DATABASE [pubs] SET RECOVERY FULL是产生日志。 转载于:https://www.cnblogs.com/todd/archive/2005/05/16/156636.html