一、重建数据库日志
1、赋予sa用户sybase_ts_role的角色
isql -Usa -P1>sp_role "grant","sybase_ts_role",sa
2>go
1>quit
2、将数据库置为"bypass recovery"状态
isql -Usa -P
1>sp_configure "allow updates",1
2>go
1>use master
2>go
1>update sysdatabases set status=-32768
2>where name="库名"
3>go
1>shutdown with nowait
2>go
3、rebuild数据库日志
重启Server
isql -Usa -P
1>use master
2>go
1>dbcc rebuild_log(库名,1,1)
2>go
1>shutdown with nowait
2>go
4、重启server
1>use master
2>go
1>update sysdatabases set status=0 where name="库名"
2>go
1>sp_configure "allow updates",0
2>go
1>shutdown with nowait
2>go
二、修复数据库日志