日志清空不了(已解决)

robinhm

是不是sybase 的bug; 打最新的EBF試一下;

donniejeck

1> sp_spaceused
2> go
database_name                  database_size
------------------------------ -------------
WDZX                           52548.0 MB
reserved        data            index_size      unused
--------------- --------------- --------------- ---------------
48033524 KB     305516 KB       47597950 KB     130058 KB

donniejeck

1> select @@version
2> go




-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
----------------
Adaptive Server Enterprise/12.5.3/EBF 13331 ESD#7/P/NT (IX86)/OS 4.0/ase1253/19

         51/32-bit/OPT/Fri Mar 24 02:17:56 2006

robinhm

補丁的確是目前最高的啦, 我無語了; 高手來解答吧!

donniejeck

1> sp_helpsegment 'logsegment'
2> go
segment name                           status
------- ------------------------------ ------
       2 logsegment                          0
device                         size
------------------------------ ----------------------
WDZX_log                       9188.0MB
free_pages
-----------
       22572
table_name                     index_name                     indid
------------------------------ ------------------------------ ------
syslogs                        syslogs                             0
total_size        total_pages     free_pages      used_pages
         reserved_pages
----------------- --------------- --------------- ---------------
         ---------------
9188.0MB          4704256         22572           18508
         90
(return status = 0)

1> dbcc usedextents (4,0,0,1)
2> go
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.

donniejeck

Disk piece 24485376 (2417664 pages), extents used = 13593, free = 288615
Disk piece 24485376:  unreserved pages array claims free pages = 2299815, but
this function counted 2299775
Disk piece 26903040 (1536 pages), extents used = 0, free = 192
74 bad per-diskpiece page counts were found in dbtable.
Those for data or data-and-log were corrected in memory;
dedicated log segment page counts are not changed by this function.
Total used extents = 3015434
Total free extents = 347638
Total extents = 3363072
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.

Eisen

很危险的方法——
手工单用户命令行方式启动ASE,用-T7446标记，
然后dbcc sysgam(dbname)试试。

回族四少

看着是已解决进来的，却没有搞明白楼主最后是怎么解决的。。。