Tag: transaction log

SAP Sybase IQ for more than a decade has resided with an embedded SQL Anywhere instance. SQL Anywhere handles the grunt tasks of managing connections and the like while IQ does what it does best: be a DATA WAREHOUSE. No, your 4 terabyte database doesn’t make it a data warehouse simply because it is big. A data warehouse is a complete different animal to your DBMS.

If you want to backup the transaction log, you simply need to issue a command:

Of course, if you are performing incremental backups, you will want to modify the dump tran @dbName with truncate only line to read something like dump tran @dbName to “/sybdumps/mydb_tran.dmp”. Modify to suit your naming standard.