Error 242

"Incomplete transactions prevent transaction log renaming"

Item Description

SQLCode

-242L

Constant

BACKUP_CANNOT_RENAME_LOG_YET

SQLState

WB003

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

2183

Severity Code

20

Probable cause

The last page in the transaction log was read by a call to db_backup. One or more currently active connections have partially completed transactions, preventing the transaction log file from being renamed. Reissue the db_backup call.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com