MsSQL disk space is insufficient.
ZookeeperI. How does msSQL errorlog cause insufficient disk space?Execute EXEC sp_cycle_errorlog to generate a new errorlog to overwrite the old errorlog. The errorlog can be overwritten once every 7 cycles.
Ii. Simple log and Database File compression method1. right-built Database Properties window-fault recovery model-set to simple; 2. right-create all tasks of the database-shrink the database; 3. right-click the database Properties window-fault recovery model-set as a large-capacity log record.Script code: USE [master] goalter database DBName set recovery simple with NO_WAITGOALTER DATABASE DBName set recovery simple -- SIMPLE mode GO
USE DBNameGODBCC SHRINKFILE (N 'dbname _ log', 11, TRUNCATEONLY)
GOUSE [master] goalter database DBName set recovery full with NO_WAITGOALTER DATABASE DBName set recovery full -- restore to FULL mode GO