在sqlserver2005/2008中备份数据库，收缩日志文件

来源：互联网发布：lte无线网络优化编辑：程序博客网时间：2024/05/01 19:37

---1.先备份数据库(含日志文件）use myhisgobackup database myhis to disk='d:\myhis_rzbak'go---2.设为简单恢复模式use [master] goalter database myhis set recovery simple with no_wait goalter database myhis set recovery simple go---3.收缩数据库日志文件为8Muse myhisgodbcc shrinkfile(myhis_log,8)go---4.重新设为完整恢复模式use mastergoalter database myhis set recovery full with no_wait goalter database myhis set recovery fullgo

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

0 0