--清除sqlserver 2000/2005 数据库日志
declare @databasename varchar(15)select @databasename='your_database'DUMP TRANSACTION @databasename WITH NO_LOGBACKUP LOG @databasename WITH NO_LOG
DBCC SHRINKDATABASE(@databasename)
**********************************--清除sqlserver 2008 数据库日志 ,执行两遍 需要将数据库日志先备份一下到本地磁盘。这个最后可以删除。use your_databasedeclare @databasename varchar(100)
declare @databasenamelog varchar(100)declare @databasenamedir varchar(100)select @databasename='your_database'select @databasenamelog=@databasename+'_log'select @databasenamedir='g:\datalogbak\'+@databasenameBACKUP LOG @databasename to
DBCC SHRINKFILE (@databasenamelog,1)