Skip to Content

Sybase IQ 16 Backup and Restore (interactive sql)

Dear IQ Gurus,

We want to backup and restore via Interactive SQL

Database name : iqdemo

Backup directory C:\backup

Could you please help me on syntax ?

Best Regards

backup.png (7.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 13, 2015 at 03:51 PM

    Here's the manual on the BACKUP DATABASE command:

    SyBooks Online

    Here's a link with examples:

    http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01759.1604/doc/html/wil1369833287354.html

    Something like this in its simplest form:

    BACKUP DATABASE

      TO 'c:\\backup\\iq_backup.full.2015-01-13'

    WITH COMMENT 'Jan 13 2015 full backup'

    Mark

    Add comment
    10|10000 characters needed characters exceeded