C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA
登录数据库后新建一个查询
---设为简单恢复模式 use [master] go
alter database ‘数据库名’ set recovery simple with no_wait;
alter database ‘数据库名’ set recovery simple;
---收缩数据库日志文件为8M use myhis go
dbcc shrinkfile(‘数据库名_log’,Targetsize);
alter database ‘数据库名’ set recovery full with no_wait;
alter database ‘数据库名’ set recovery full;
登录数据库后新建一个查询
---设为简单恢复模式 use [master] go
alter database ‘数据库名’ set recovery simple with no_wait;
alter database ‘数据库名’ set recovery simple;
---收缩数据库日志文件为8M use myhis go
dbcc shrinkfile(‘数据库名_log’,Targetsize);
alter database ‘数据库名’ set recovery full with no_wait;
alter database ‘数据库名’ set recovery full;
Targetsize:单位为兆,必须为整数,DBCC SHRINKFILE 尝试将文件收缩到指定大小。