日志文件比较大时,使用语句减少大小. USE DATABASENAME;GO-- Truncate the log by changing the database recovery model to SIMPLE.ALTER DATABASE DATABASENAMESET RECOVERY SIMPLE;GO-- Shrink the truncated log file to 1 MB.DBCC SHRINKFILE (DATABASENAME_Log, 1);GO-- Reset the
use mydb ALTER DATABASE mydb SET RECOVERY SIMPLE WITH NO_WAIT ALTER DATABASE mydb SET RECOVERY SIMPLE --简单模式 , TRUNCATEONLY) -- 11是大小 11M ALTER DATABASE mydb SET RECOVERY FULL WITH NO_WAIT ALTER DATABASE mydb SET RECOVERY FULL --还原为完全模式
net stop nginx taskkill /im nginx.exe /f cd E:\nginx e: set NO=%Date:~0,4%%Date:~5,2%%Date:~8,2% set t=%Time% if "%t:~0,1%" ==" " ( set t=0%t:~1% ) set NO=%Date:~0,4%%Date:~5,2%%Date:~8,2%%t:~0,2%%t:~3,2%%t:~6,2% move logs\access.log b