需要急救！！！前辈们帮忙看看！！！

RS9000

请教请教斑竹吧。。。他是高手

ywtmh

连RS9000大哥都搞不定，看来问题不小啊，急等版主出现啊！！！

zhangyh123

看看这个解释
This is a log corruption and the only way (which of course will get rid of
the transaction logs yet to be applied/rolled back) is to do a dbcc
rebuild_log

dbcc rebuild_log(<dbid>;,1,1)

you need to put the database in bypass mode (changing the
sysdatabases.status=-32768 for this database) and reboot before you
rebuild the log.

This is the extreme way of salvaging data but then there is no escape from
a 3414 (apart from if the sysusages fragments are tampered with) besides
restoring from a clean backup.

zhangyh123

或者这个也可以
You're in trouble (or rather, your database is). You're basically looking
at a corrupted transaction log. There's no easy way to fix this. Also, the
fact that this applies to sysindexes (object 2) is not good news. I've had
this problem (error 3474) once before, and the only thing we could do was
to get rid of the transaction log and build a new one (using dbcc
rebuild_log, which is a *very* heavy-handed approach that's only a
last-resort measure). However, as you have a problem with sysindexes, this
doesn't sound like a good idea, as it might leave sysindexes corrupted.
Also, there seems to be a lot of stuff in the log, given all the redo
messages. You'd loose these when rebuilding the log. I'd recommend to
first try to extract your data out of that database, build a new database,
and load the data there. To extract the data, update the status column in
sysdatabases to -32768 for your database and cycle the server. When it's
restarted, use BCP or 'select into' to move your data out of this
database. Then drop (or rename) the current database and create a new one.

zhangyh123

最后一个
1>; use master
2>; go
1>; select count(*) from your_database..syslogs
2>; go

-----------
some number

1>; sp_configure "allow updates",1
2>; go
1>; reconfigure with override  /* for system 10 and below only*/
2>; go

1>; begin tran
2>; go

/* Save the following status to be used later... */
1>; select saved_status=status from sysdatabases where name = "your_database"
2>; go
1>; update sysdatabases set status = -32768 where name = "your_database"
2>; go
1>; commit tran
2>; go
1>; shutdown
2>; go

1>; dbcc rebuild_log (your_database, 0, 0)
2>; go
DB-LIBRARY error (severity 9):
   Unexpected EOF from SQL Server.

1>; dbcc rebuild_log (your_database, 1, 1)
2>; go
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.


1>; use your_database
2>; go
1>; select count(*) from syslogs
2>; go

-----------
           1

1>; begin tran
2>; go
1>; update sysdatabases set status = saved_status where name = "your_database"
2>; go
(1 row affected)
1>; commit tran
2>; go
1>; shutdown
2>; go

NoGame

dbcc 不能执行，报以下错误：

1＞dbcc rebuild_log('dbname', 1, 1)
2>; go

DBCC execution complieted. If DBCC printed error messages, contact System Administrator (sa) role.

ywtmh

详细，如果是中文就更好了！！！大有帮助啊！！！

zhangyh123

原帖由 "NoGame" 发表：
dbcc 不能执行，报以下错误：

1＞dbcc rebuild_log('dbname', 1, 1)
2>; go

DBCC execution complieted. If DBCC printed error messages, contact System Administrator (sa) role.

这个不是已经执行了么？

NoGame

非常感谢！！！
可以打开了

zhangyh123

兄弟，不要这样，将过程详细写一下，供大家参考呀

错误发生的原因，现象，解决方法等