日志清空不了(已解决)

hobbylu

use dbname
go
dbcc gettrunc
go

donniejeck

1> use WDZX
2> go
1> dbcc gettrunc
2> go
ltm_truncpage ltm_trunc_state db_rep_stat gen_id      dbid
         dbname                         lti_version
------------- --------------- ----------- ----------- ------
         ------------------------------ -----------
             0               0           0           0      4
         WDZX                                     0

donniejeck

原帖由 shawnlee 于 2008-7-28 10:14 发表
重起也不行?

重起也没用

donniejeck

dbcc rebuild_log(WDZX,1,1)
也不好使

Eisen

dump tran dbname with truncate_only
dump tran dbname with no_log

sp_dboption dbname,'trunc',true

sp_config_rep_agent dbname,'disable'

以上方法都试过吗?

donniejeck

我的应用没有使用复制

donniejeck

1> dbcc tablealloc(syslogs,full,fix)
2> go
***************************************************************
TABLE: syslogs          OBJID = 8
INDID=0  FIRST=20164088  ROOT=20164088   SORT=0
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
Alloc page 20163840 (# of extent=1 used pages=8 ref pages=1)
Total (# of extent=1 used pages=8 ref pages=1) in this database
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.



DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
The default report option of OPTIMIZED is used for this run.
The default fix option of NOFIX is used for this run.
***************************************************************
TABLE: syslogs                OBJID = 8
INDID=0         FIRST=17828323         ROOT=17828324         SORT=0
        Data level: 0.  2 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
Alloc page 17828096 (# of extent=1 used pages=5 ref pages=2)
Total (# of extent=1 used pages=5 ref pages=2) in this database

Statistical information for this run follows:
Total # of pages read = 2
Total # of pages found cache = 1
Total # of physical reads = 1
Total # of saved I/O = 0
Size of I/O used = 8 pages
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.


DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
Syslogs free space count has been successfully recalculated. It has been
corrected to 25015 pages.
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.

robinhm

select spid from master..syslogshold

kill spid

dump tran dbname with truncate_only

如果還不行, 就
dump tran dbname with no_log

應該可以的;

donniejeck

没有最早的事务存在.