有时候日志段空间满了使用下列语句也无济于事,又不能直接重启库,就加空间应急,
dump tran mydb with truncate_only
sp_helpdevice
go
sp_helpdb tsmcore
go
sp_helpsegment logsegment
select name,phyname,vdevno from sysdevices
go
disk init
name="tsmcore_log_01",
physname="/sybdata2/tsmcore/tsmcore_log_01.dat",
size="1024M"
go
alter database tsmcore log on tsmcore_log_01="1024M";
dump tran mydb with truncate_only
dump tran mydb with no_log
sp_helpdevice
go
sp_helpdb tsmcore
go
sp_helpsegment logsegment
select name,phyname,vdevno from sysdevices
go
disk init
name="tsmcore_log_01",
physname="/sybdata2/tsmcore/tsmcore_log_01.dat",
size="1024M"
go
alter database tsmcore log on tsmcore_log_01="1024M";
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/308563/viewspace-2136313/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/308563/viewspace-2136313/