恢复Sybase ASE 15.0.x中的master数据库是一件比较痛苦的事情,官方文档有时候也未免解说不够详细,自己动起手来又完全不是那么回事,尤其是涉及到字符集问题的时候。下边是详细的恢复过程。
一、准备工作
1. 备份
启动备份服务器,Adaptive Server以-m方式启动,将master数据库备份出来
1> dump database master to 'd:\sybase\master.dump'
2> go
WARNING: In order to LOAD the master database, the ASE must run in single-user
mode. If the master database dump uses multiple volumes, you must execute
sp_volchanged on another ASE at LOAD time in order to signal volume changes.
Backup Server session id is: 5. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: