How to do a restore

[Yardyy]

Hi, We have a sybase v6 database, and we use a small script to backup each night.

dbbackup -c "dsn=nma" -y -q n:\nm_backup

this generates two files one is called ptadata.edb and one called ptadata.log, i need to restore the data back, as the database is corrupt.

Could someone please show me how to restore a backup, just the syntax would be good.

Regards

Many Thanks
Yurov Ardyy

 

[PDreyer]

I haven't used SQL Anywhere for some time but if I remember correct you can just stop the database engine, replace the database files with the files from the backup and restart.

I think this forum is more related to Adaptive Server Enterprise than to SQL Anywhere

You might have better luck posting at an SQL Anywhere newsgroup e.g. sybase.public.sqlanywhere.general

 

[Yardyy]

I tried that already, and it was saying that the log files are not from the same database, but thanks for your reply and suggestion for the link.

Many Thanks
Yurov Ardyy