一大早用户就报,SQL SERVER日志满了。
执行语句参考:
ALTER DATABASE CARDB SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE CARDB SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (N'Test20130116_standard_log' , 1024, NOTRUNCATE)
go
DBCC SHRINKFILE (N'Test20130116_temp2_log' , 1024, NOTRUNCATE)
go
ALTER DATABASE CARDB SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE CARDB SET RECOVERY FULL
GO