databasesybasesap-aseisql

Bring Sybase database offline

Is there a way to bring a database offline in Sybase ASE 16.0?

I know a database gets set offline when loading a dump, but that can't be the only way to set a database offline.


There is also an official article for that, but it's locked behind a PayWall...

Solution

  • DBA-level direct edit of system catalog would place it into that state. Try it on a dev instance to see if this is what you were looking for in re: offline database command.

    sp_configure 'allow updates',1
go

reconfigure with override
go

update master..sysdatabases 
set status=512 
where name='<database of interest>'
go

sp_configure 'allow updates',0
go

reconfigure with override
go

    Other states you might look into would be:

    512  offline 
1024 read only 
2048 dbo use only 
4096 single user

    Some of these states can be set via the sp_dboption calls, like

    master..sp_dboption <database of interest>, "read", true
go