sybase数据库压缩备份后恢复是报错：4.126.3.1:unable get current date and time

reiky

sybase数据库如果在备份的时候加上参数compress参数时，恢复时报错：backup server internal error:4.126.3.1:unable get current date and time.
但是备份时不加compress参数时数据恢复成功，麻烦各位大虾帮忙看一下，谢谢！

Reiky

哪位大虾知道的帮忙指点一下！谢谢！

wfcjz

能否把你的情况描述清楚些

D_D_D_D

如果备份的时候加了compress参数，load的时候也要加上，是压缩级别，0-9

D_D_D_D

刚看到，哥们你的load脚本写的有问题啊，compress怎么到引号里面了。。。

xjtuhuth

回复 1# reiky


    把你的dump语句贴上来看看。

xjtuhuth

回复 1# reiky


Commands used to restore databases from dumps Use this command
To do this

create database for load
Create a database for the purpose of loading a dump.

load database
Restore a database from a dump.

load transaction
Apply recent transactions to a restored database.

online database
Make a database available for public use after a normal load sequence or after upgrading the database to the current version of Adaptive Server.

load {database | transaction} with {headeronly | listonly}
Identify the dump files on a tape.

sp_volchanged
Respond to Backup Server volume change messages.

xjtuhuth

回复 1# reiky

我在15.5试了下：
dump database test to 'compress::4::/home/test/dmp01.dmp'
create test for load...
load database test from 'compress::/home/test/dmp01.dmp'

成功。

Reiky

备份及恢复格式肯定没有问题，我的操作系统平台是IBM Power 6 570+AIX 6.1的。

wfcjz

power6.有你受的,这是新机型,有好多奇怪问题,我最近就遇到过,没把我整死.