(已解决)急！！master出现BYPASS RECOVERY mode，怎么解决！！！

backwang

先把MASTER状态改为0，重启后再改为-32768后再重启即可！

builder

原帖由 backwang 于 2006-8-22 11:42 发表
先把MASTER状态改为0，重启后再改为-32768后再重启即可！

请教怎么改呢？用isql进入修改已经提示
Attempt to BEGIN TRANSACTION in database 'master' failed because database is in
BYPASS RECOVERY mode.

不能修改成功，请老大指点，急阿！

hellojan

请版主指点呀！！！！

hobbylu

你把master库发给我吧，我给你改

hellojan

已加你的msn,QQ请加我下。

[ 本帖最后由 hellojan 于 2006-8-22 13:11 编辑 ]

backwang

先把服务停了，再在启动文件（RUN＿xxx）的命令行后面加-T　3607后直接运行RUN_XXX文件

chenfeng825

现在至少还是可以备份的！备份用户库出来重建算了，比较简单！
还有，怎么会想到手工去把master 的状态给update掉，别的库都行，独独这个不行的！
还有,3607的traceflag也不能解决这个问题

hellojan

00:00000:00005:2006/08/22 13:27:10.61 kernel  SQL causing error : sp_configure 'update',1

00:00000:00005:2006/08/22 13:27:10.61 kernel  ************************************
00:00000:00005:2006/08/22 13:27:10.61 server  SQL Text: sp_configure 'update',1
00:00000:00005:2006/08/22 13:27:10.61 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
00:00000:00005:2006/08/22 13:27:10.61 kernel  preverror = 0 transtate = 1
00:00000:00005:2006/08/22 13:27:10.61 kernel  curcmd = 193 program = isql                          
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x84340bb ucbacktrace+0x67(0x0,0x1,0x86df48c,0xb,0x43c1da7
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x80b01ad terminate_process+0x7b5(0x0,0xffffffff,0xb,0x86df48c,0x4216ee80)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x8441e74 kisignal+0x48(0xb,0x0,0x0,0x2b,0x2b)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x4007a848 address outside symbol table(0x43c19cb8,0x0,0x86df48c,0x43c19b34,0x42ab6200)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x828d2ef s__setup_tabsdes+0x4c3(0x43c19bd0,0x0,0x1,0x43c19dec,0x0)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x828cde3 s_setuptables+0x10b(0x43c19bd0,0x43c19bd0,0x86df48c,0x4100e880,0x1)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x828abdc s_execute+0x2104(0x86df48c,0x81a,0x43be7000,0x0,0x1)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x8296d91 sequencer+0xba1(0x43be7000,0x86df48c,0x4100e880,0x42ab6200,0x42ab0001)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x828ecba execproc+0x5c2(0x43becba0,0x43becc18,0x0,0x0,0x0)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x828a975 s_execute+0x1e9d(0x86df48c,0x0,0x42ab6200,0x0,0x1)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x8296d91 sequencer+0xba1(0x43be9000,0x86df48c,0x0,0x21,0x437bd219)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x80d9e05 tdsrecv_language+0x2d5(0x0,0x0,0x0,0x0,0x1)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x80cea2c conn_hdlr+0x2104(0x2,0x41070cd0,0xd285ed31,0x0,0x5374616b)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0x81052f3 ex_cleanup(0x0,0x5374616b,0x0,0x0,0x0)
00:00000:00005:2006/08/22 13:27:10.61 kernel  pc 0xd285ed31 address outside symbol table(0x0,0x0,0x0,0x0,0x0)
00:00000:00005:2006/08/22 13:27:10.61 kernel  end of stack trace, spid 5, kpid 655370, suid 1

hellojan

有二个库“suspect”，在做update时，有一没有加条件，结果就成这样了。唉！失误了。

hellojan

感谢hobbylu ，帮我解决了大问题