USE dbname GO ALTER DATABASE dbname SET RECOVERY SIMPLE;--设置简单恢复模式 GO DBCC SHRINKFILE (dbname_Log, 1); GO ALTER DATABASE dbname SET RECOVERY FULL;--恢复为原模式 GO
dbname为数据库名称
USE dbname GO ALTER DATABASE dbname SET RECOVERY SIMPLE;--设置简单恢复模式 GO DBCC SHRINKFILE (dbname_Log, 1); GO ALTER DATABASE dbname SET RECOVERY FULL;--恢复为原模式 GO
dbname为数据库名称