清理SQL数据库日志

Use DB
Select NAME,size From sys.database_files
ALTER DATABASE DB SET RECOVERY SIMPLE WITH NO_WAIT ALTER DATABASE DB SET RECOVERY SIMPLE USE DB
DBCC SHRINKFILE(DB_log ,0,TRUNCATEONLY)
ALTER DATABASE DB SET RECOVERY FULL WITH NO_WAIT ALTER DATABASE DB SET RECOVERY FULL

清理SQL数据库日志

上一篇:计数排序 C语言实现版


下一篇:C语言数组