截断数据库日志作业
来源:互联网 发布:中国银行淘宝校园卡 编辑:程序博客网 时间:2024/05/29 04:34
use master
declare @logname varchar(8000),@dbname varchar(8000)
declare @SqlTxt varchar(8000)
DECLARE bk_cursor CURSOR FOR
select t2.name as logname,t1.name as dbname from sysaltfiles t2 inner join sysdatabases t1 on t1.dbid=t2.dbid where t2.fileid=2 and t1.dbid>5 and t1.mode=0
OPEN bk_cursor
FETCH NEXT FROM bk_cursor into @logname,@dbname
WHILE @@FETCH_STATUS = 0
BEGIN
set @SqlTxt = 'use ' + @dbname + '; '
set @SqlTxt = @SqlTxt + 'BACKUP LOG ' + @dbname + ' with no_log; '
set @SqlTxt = @SqlTxt + 'DBCC SHRINKFILE (' + rtrim(@logname) + ',500)'
exec(@SqlTxt)
FETCH NEXT FROM bk_cursor into @logname,@dbname
END
CLOSE bk_cursor
DEALLOCATE bk_cursor
declare @logname varchar(8000),@dbname varchar(8000)
declare @SqlTxt varchar(8000)
DECLARE bk_cursor CURSOR FOR
select t2.name as logname,t1.name as dbname from sysaltfiles t2 inner join sysdatabases t1 on t1.dbid=t2.dbid where t2.fileid=2 and t1.dbid>5 and t1.mode=0
OPEN bk_cursor
FETCH NEXT FROM bk_cursor into @logname,@dbname
WHILE @@FETCH_STATUS = 0
BEGIN
set @SqlTxt = 'use ' + @dbname + '; '
set @SqlTxt = @SqlTxt + 'BACKUP LOG ' + @dbname + ' with no_log; '
set @SqlTxt = @SqlTxt + 'DBCC SHRINKFILE (' + rtrim(@logname) + ',500)'
exec(@SqlTxt)
FETCH NEXT FROM bk_cursor into @logname,@dbname
END
CLOSE bk_cursor
DEALLOCATE bk_cursor
阅读全文
0 0
- 截断数据库日志作业
- 数据库日志截断
- 截断数据库日志
- SQLServer2008 截断数据库日志
- SQL Server数据库日志截断
- 截断监听数据库日志文件
- sql server 数据库日志过大,截断日志
- 复制导致数据库日志无法截断收缩
- 截断日志
- 日志截断
- 命令行备份数据库、恢复数据库、截断数据库日志
- 数据库运用_减小物理日志文件的大小=截断事务日志+收缩事务日志
- SQL Server 日志截断
- mssql日志截断
- 事务日志截断
- MsSql截断收缩日志
- MSSQL2005截断日志
- Alwayson如何截断日志
- mysql 连接报错
- margin+padding实现居中
- 阿里巴巴 JAVA 开发手册--总结
- java解析json数据
- larvel 启动队列
- 截断数据库日志作业
- 记录修改tomcat编码格式
- ZBrush 4R8 Mac破解版下载附激活教程
- Android自定义view浅谈(二) measure layout 和draw
- HTTP中Get与Post的区别
- Spring Boot(一) 入门
- D3D 11高分辨率定时器
- DDoS攻击类型及工具总结
- Android——浅谈事件分发机制