更新一个SQL Server 日志数据库清理脚本,以备日后用到。
USE [master] GO ALTER DATABASE [数据库名称] SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE [数据库名称] SET RECOVERY SIMPLE GO USE [数据库名称] GO DBCC SHRINKFILE (N'[数据库日志文件名称]' , 0,TRUNCATEONLY) GO USE [master] GO ALTER DATABASE [数据库名称] SET RECOVERY FULL WITH NO_WAIT GO ALTER DATABASE [数据库名称] SET RECOVERY FULL GO