Unanswered: Sybase - How to load DB in offline mode
How to load Sybase database in offline mode?
Tried the sp_dboption single user and get the following error.
Error :"Database in use.A user with System Administrator (SA) role must have exclusive use of database to run load".
There is a master database. In that we have -
We want to -
" use master
load database agc from "/var/spool........"
but when we load the database we get the below error.
" Msg 3101, Level 16, State 1:
Server 'SYBASE', Line 1:
Database in use. A user with System Administrator (SA) role must have exclusive use of database to run load. "
You cannot load database whilst its in use, meaning users are logged on, hence sybase forces users to log out or you kill them. write a small shell that can do this for you everytime you try to load databases.