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;

 

CreateTimeStamp

DatabaseName

TVMName

2018-05-25 14:36

DatabaseA

Table1

 

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);

 

Comments