USE[master]
GO
ALTER DATABASE hydee_wtlpf SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE hydee_wtlpf SET RECOVERY SIMPLE --简单模式
GO
USE hydee_wtlpf
GO
DBCC SHRINKFILE (N'Csoft_log' , 11, TRUNCATEONLY) --Csoft_log 是数据库日志文件名称。具体名字可以通过数据库文件查看
GO
USE[master]
GO
ALTER DATABASE hydee_wtlpf SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE hydee_wtlpf SET RECOVERY FULL --还原为完全模式
GO
GO
ALTER DATABASE hydee_wtlpf SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE hydee_wtlpf SET RECOVERY SIMPLE --简单模式
GO
USE hydee_wtlpf
GO
DBCC SHRINKFILE (N'Csoft_log' , 11, TRUNCATEONLY) --Csoft_log 是数据库日志文件名称。具体名字可以通过数据库文件查看
GO
USE[master]
GO
ALTER DATABASE hydee_wtlpf SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE hydee_wtlpf SET RECOVERY FULL --还原为完全模式
GO