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

jopen 9年前

    ---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 master                    alter database '+@database+'  set recovery full with no_wait                    alter database '+@database+'  set recovery full')                         ---使用示例            --execute proc_database 'AmazonErp'          end