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
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