7595:Operation not allowed: an online archive logging is currently active on <database_name>

Cause:

This is caused by having the online logging already enabled for this particular object.

Solution:

Use the following SQL to check online logging is in use:

select

CreateTimeStamp,

DatabaseName (VARCHAR(30)),

TVMName (VARCHAR(30))

from

DBC.ArchiveLoggingObjsV;

Please check with your DBA, if the online backup is running then wait until backup is complete.

This example stops online archive logging on Table1.

LOGGING ONLINE ARCHIVE OFF FOR (DatabaseA.Table1);

This example stops online archive logging on all the tables in the DatabaseA.

LOGGING ONLINE ARCHIVE OFF FOR (DatabaseA);