SAP Knowledge Base Article - Preview

2440368 - Error 5066 when running shrink db 'alter database off' command - SAP ASE


  • Using the 'shrink database' command 'alter database off' option to remove a device
  • The command returns error 5066:

1> alter database my_db off my_device 
2> go

Msg 5066, Level 16, State 1: Server 'ASE', Line 1:
Table 'my_table' contains off-row columns that do not link back to their owning rows.
Run dbcc shrinkdb_setup to set up back links for this database.



SAP Adaptive Server Enterprise


SAP Adaptive Server Enterprise all versions


unused by any segment, alter database off, dbcc shrinkdb_setup, Msg 5066, "off-row columns" , message 5066 , 5066 , 'shrink db' , 'shrink database' , dbcc shrinkdb , shrinkdb , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.