Sql2000清除日志文件
USE databasename
GO
backup log databasename with no_log
DBCC SHRINKFILE (databasename_Log, 7)
GO
sql2005清除日志文件
dump transaction databasename with no_log
收缩日志文件释放可用空间即可
Sql2000清除日志文件
USE databasename
GO
backup log databasename with no_log
DBCC SHRINKFILE (databasename_Log, 7)
GO
sql2005清除日志文件
dump transaction databasename with no_log
收缩日志文件释放可用空间即可