康拍樂 compiler note

SELECT name, recovery_model_desc  FROM sys.databases --修改簡單模式 USE master ; ALTER DATABASE TESTDB SET RECOVERY SIMPLE;

SELECT name, physical_name ,size FROM sys.master_files order by size desc