哪个银行的?作者: fastethernet 时间: 2005-07-25 17:03 标题: Syabase 新建的日志为啥没有用? sp_helpdb "userdb1"
4>; go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
------------------------------------------------------------------------------------------------------
userdb1 3300.0 MB sa 7
Jul 20, 2005
no options set
(1 row affected)
device_fragments size usage free kbytes
------------------------------ ------------- -------------------- -----------
userdb 850.0 MB log only 36096
userdb2 850.0 MB log only 328592
userdb3 200.0 MB data only 65088
userdb3 300.0 MB log only 64480
userdb3 350.0 MB log only 358400
userdb4 750.0 MB log only 664784
(return status = 0)
_____________________________
我清除日志的方法:dump transaction with truncate_only .....