Skip to Content
1
Former Member
Jun 19, 2014 at 06:34 AM

Sybase IQ Point in time recovery backup

255 Views

Hi ,

I was trying to Setup Sybase IQ Point in time recovery log backup as per the Admin guide in SP08 .

As per the guide , We should enable it like as below:

1. SET OPTION PUBLIC.IQ_POINT_IN_TIME_RECOVERY_LOGGING = 'ON'

2. ALTER DBSPACE IQ_SYSTEM_LOG RENAME '/My Directory/<prefix> '

3. BACKUP DATABASE FULL to '/demo/dataBackup/FULL1'

After 2nd step , DB is getting crashed with below error :

-----------------

Error! The connection to the database was closed by the server.

Communication error

SQLCODE=-85, ODBC 3 State="08S01"

Line 1, column 1

ALTER DBSPACE IQ_SYSTEM_LOG RENAME My Directory/<prefix>

--------------------

I tried for creation IQ_SYSTEM_LOG but says the

"CREATE DBSPACE IQ_SYSTEM_LOG AS ' My Directory/<prefix>"

Could not execute statement.

Item 'IQ_SYSTEM_LOG' already exists

SQLCODE=-110, ODBC 3 State="42S01"

Line 1, column 1

CREATE DBSPACE IQ_SYSTEM_LOG AS '/ My Directory/<prefix>'

----------------------------------------

I tried the following SQL to check current DBSPACES

select * from SYSDBSPACE but IQ_SYSTEM_LOG is not listed

-----------------------

Can someone please help me here for the same and share best practices, So that i can enable automatic backups .

Thanks,

Razal