-- 查看错误日志
EXEC xp_ReadErrorLog 0, 1, 'Failed', '', '2016-06-01', '2016-06-04', 'DESC'
-- 查看各个库日志使用
DBCC SQLPERF (Logspace)
-- 收缩日志sqlserver2008
USE [master]
GO
ALTER DATABASE DB_NAME SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE DB_NAME SET RECOVERY SIMPLE --简单模式
GO
USE DB_NAME
GO
DBCC SHRINKFILE (N'DB_NAME_Log',0,TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE DB_NAME SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE DB_NAME SET RECOVERY FULL --还原为完全模式
GO
-- 手动修改为简单模式
USE [master]
GO
ALTER DATABASE [DB_NAME] SET RECOVERY SIMPLE WITH NO_WAIT
GO
EXEC xp_ReadErrorLog 0, 1, 'Failed', '', '2016-06-01', '2016-06-04', 'DESC'
-- 查看各个库日志使用
DBCC SQLPERF (Logspace)
-- 收缩日志sqlserver2008
USE [master]
GO
ALTER DATABASE DB_NAME SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE DB_NAME SET RECOVERY SIMPLE --简单模式
GO
USE DB_NAME
GO
DBCC SHRINKFILE (N'DB_NAME_Log',0,TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE DB_NAME SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE DB_NAME SET RECOVERY FULL --还原为完全模式
GO
-- 手动修改为简单模式
USE [master]
GO
ALTER DATABASE [DB_NAME] SET RECOVERY SIMPLE WITH NO_WAIT
GO