有关Sybase12.5重置"sa"口令的个人测试

7/31/2008来源:Sybase教程人气:8061

今天,做了一个测试,目的是把sa口令丢失情况下重置。


先停掉服务,而后修改Run_XXX.bat(XXX为服务名)。

我的实例如下:


rem

e:\sybase\ASE-12_5\bin\sqlsrvr.exe -de:\oadb\master.dat -scq -ee:\oadb\cq.log -ie:\sybase\ini -Me:\sybase\ASE-12_5 -psa


直接双击运行该批处理文件,启动数据库。控制台显示口令如下:


00:00000:00001:2005/11/08 15:43:23.56 server Database 'sybsystemPRocs' is now o

nline.


New SSO passWord for sa:bqsfwvnrpuiib8(此为新口令)


00:00000:00010:2005/11/08 15:43:23.67 kernel network name donnie, interface ipv

4, address 10.185.1.107, type nlwnsck, port 5000, filter NONE

00:00000:00001:2005/11/08 15:43:23.85 server The wash size of the 2K buffer poo

l in cache default data cache has been changed from 1638 Kb to 984 Kb due to a c

hange in the size of the pool.

00:00000:00001:2005/11/08 15:43:23.87 server Recovery has tuned the size of '16

K' pool in 'default data cache' to benefit recovery performance. The original co

nfiguration will be restored at the end of recovery.