---1.先备份数据库(含日志文件)
use myhis
go
backup database myhis to disk='d:\myhis_rzbak'
go
---2.设为简单恢复模式
use [master]
go
alter database myhis set recovery simple with no_wait
go
alter database myhis set recovery simple
go
---3.收缩数据库日志文件为8M
use myhis
go
dbcc shrinkfile(myhis_log,8)
go
---4.重新设为完整恢复模式
use master
go
alter database myhis set recovery full with no_wait
go
alter database myhis set recovery full
go
alter proc proc_database @database nvarchar(50)as begin ---1.先备份数据库(含日志文件) execute('use '+@database+' backup database '+@database+' to disk=''d:\'+@database+'_rzbak''') ---2.设为简单恢复模式 execute(' use [master] alter database '+@database+' set recovery simple with no_wait alter database '+@database+' set recovery simple') ---3.收缩数据库日志文件为8M execute(' use '+@database+'dbcc shrinkfile('+@database+'_log,8)')---4.重新设为完整恢复模式execute(' use masteralter database '+@database+' set recovery full with no_waitalter database '+@database+' set recovery full') ---使用示例--execute proc_database 'AmazonErp' end