Sybase ASE 12.5.4数据库安装备份还原操作步骤

Sybase ASE 12.5.4数据库安装备份还原操作步骤

测试环境：WINDOWS7+64位操作系统+syb_12_5_4 for window数据库软件。

操作步骤如下：

一、安装数据库

二、备份数据库

三、还原数据库

四、问题经验总结

4.1、安装时候选择完全版本，会自带客户端连接软件，默认安装完成后的管理员sa对应的密码为空。

4.2、备份时候，在DOS下使用命令备份dump database JScms to "d:\backdat\JScms.dat" //备份到本地磁盘

4.3、还原时候，在DOS下使用命令还原load database JScms from "d:\backdat\JScms.dat" //从本地磁盘文件还原数据库

4.4、还原成功后，在DOS下使用命令online database JScms//执行上线运行命令

五、成功还原数据库的DOS操作记录

------------------------------------------------------------------------------------------
Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:\Users\Administrator>isql -U sa -P
1> use master
2> go
1> load database JScms from "d:\backdat\JScms.dat"
2> go
Backup Server session id is:  10.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'JScms181051308C  ' section number 1
mounted on disk file 'd:\backdat\JScms.dat'
The database 'ICOURT' is currently not available and cannot be checked for
cross-database encryption key references for the keys existing in database
'JScms'.
Backup Server: 4.58.1.1: Database JScms: 44038 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 87304 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 130570 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 173582 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 217102 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 260114 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 303634 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 346646 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 390166 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 432666 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 476186 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 519198 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 524318 kilobytes LOADED.
Backup Server: 4.58.1.1: Database JScms: 524326 kilobytes LOADED.
Backup Server: 3.42.1.1: LOAD is complete (database JScms).
All dumped pages have been loaded.  SQL Server is now clearing pages above page
262144, which were not present in the database just loaded.
SQL Server has finished clearing database pages.
Started estimating recovery log boundaries for database 'JScms'.
Database 'JScms', checkpoint=(211214, 17), first=(211214, 17), last=(211214,
17).
Completed estimating recovery log boundaries for database 'JScms'.
Started ANALYSIS pass for database 'JScms'.
Completed ANALYSIS pass for database 'JScms'.
Started REDO pass for database 'JScms'. The total number of log records to
process is 1.
Completed REDO pass for database 'JScms'.
Use the ONLINE DATABASE command to bring this database online; SQL Server will
not bring it online automatically.
1> online database JScms
2> go
Started estimating recovery log boundaries for database 'JScms'.
Database 'JScms', checkpoint=(211214, 17), first=(211214, 17), last=(211214,
17).
Completed estimating recovery log boundaries for database 'JScms'.
Started ANALYSIS pass for database 'JScms'.
Completed ANALYSIS pass for database 'JScms'.
Recovery of database 'JScms' will undo incomplete nested top actions.
Database 'JScms' is now online.