清除SQL-LOG文件,获得硬盘空间
SELECT file_id, name FROM sys.database_files; ALTER DATABASE TheDBName SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (TheDBName_Log, 1); GO -- Reset the database recovery model. ALTER DATABASE TheDBName SET RECOVERY FULL; GO