1999458 - DUMP TRAN command raises error Msg 4205 "Syslogs does not exist in its own segment..." - SAP ASE

• Running a 'dump transaction' to 'file' command
• On a database with no dedicated log segment
• sp_helpdb showing 'mixed log and data' in Status field and
• sysusages.segmap for that database shows a value of "7"
  
  
• Results in error 4205:

Msg 4205, Level 16, State 1:
Server 'ASE', Line 1:
Syslogs does not exist in its own segment in database '<database>' with segmap '7' with logical start page number of '0'.
You cannot use DUMP TRANSACTION in this case, use DUMP DATABASE instead.

SAP Adaptive Server Enterprise (ASE). Not version specific.

4205 , sp_logdevice , "mixed data and log segment" , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem