sql2000数据库日志满了,可以运行以下语句进行清理
DUMP TRANSACTION DBNAME WITH NO_LOG
BACKUP LOG DBNAME WITH NO_LOG
DBCC SHRINKDATABASE(DBNAME)
sql2008日志清理:
USE [master]
GO
ALTER DATABASE dbname SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE dbname SET RECOVERY SIMPLE
GO
USE dbname
GO
DBCC SHRINKFILE (N'dbname_Log' , 0,TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE dbname SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE dbname SET RECOVERY FULL
GO
3用管理工具的收缩方法
先把数据库设成简单模式;
ALTER DATABASE tablename SET RECOVERY SIMPLE --简单模式
再任务中选择收缩数据库;
最后还原为完全模式;
ALTER DATABASE tablename SET RECOVERY FULL --还原为完全模式