重建系统日志的语句:仅供参考:一定要备份好账套,以免操作失误造成数据丢失,数据丢失无法恢复,请慎重:
alter database ufdata_111_2016 set emergency
go
alter database ufdata_111_2016 set single_user with rollback immediate
go
use master
go
alter database ufdata_111_2016 Rebuild Log on
(name=SuspectDB_log,filename='D:\用友T6SOFT\Admin\Z用友T111\2016\ufdata.LDF')
go
alter database ufdata_111_2016 set multi_user
go
DBCC CHECKDB('ufdata_111_2016')
go