Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question