SELECT NAME, size FROM sys.database_files

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