sqlserver2008收缩数据库脚本

---
先备份数据库(含日志文件）
use
myshopcmstock
go  
backup database myshopcmstock to disk = 'e:\myshopcmstock_rzbak' 
go 
---
设为简单恢复模式
use
master
go
alter database myshopcmstock set recovery simple with no_wait
go  
alter database myshopcmstock set recovery simple
go 
---
收缩数据库日志文件为100M 
use
myshopcmstock 
go  
dbcc shrinkfile (myshopcmstock_log,100) 
go 
---
重新设为完整恢复模式
use
master 
go  
alter database myshopcmstock set recovery full with no_wait  
go