SELECT NAME, size FROM sys.database_files
select name, recovery_model_desc from sys.databases alter database 數據庫名稱 set Recovery simpleDBCC SHRINKFILE(N'查詢出來的內部日志名稱',10) ALTER DATABASE 數據庫名稱 SET Recovery FULL