0

I need to load a database dump into a target database, on Sybase ASE 16. In order to do that, the target database must be offline. Sybase ASE doesn't have a command to put a database offline, so my only possibility is to stop the DB server and restart it, taking care that the target database is not brought online during startup. This is my question: which command/option do I need to set so that a specific database is not brought online at server startup? I couldn't find it in the official documentation :-(

6
  • 1
    I don't agree with your statement "target database must be offline" - It must not be used by anyone else and you need to have exclusive access in order to start loading. That's the only criteria. if database is offline - how will you load it? Aug 10, 2020 at 12:18
  • You mean to set it in single user mode? I could try that. For your other comment, loading a DB from offline status has worked in the past.
    – Lupuss
    Aug 10, 2020 at 12:26
  • It seems you are using restoring and not-online database interchangeably with offline. for testing purpose, you can create one dummy database - dump the data out and load it. Just ensure that there is no active connection to that dummy database before loading and you should be able to load it. Aug 10, 2020 at 12:33
  • You may check link --> answers.sap.com/questions/11748141/… Aug 10, 2020 at 12:35
  • 2
    The target database does not need to be 'offline'; the target database does need to have no active users; have you tried loading the dump into the target and if so what happened? if you received an error then please post the (complete) error message; if you're having problems getting rid of an active user in the db then you may want to consider dbcc dbreboot
    – markp-fuso
    Aug 10, 2020 at 12:47

1 Answer 1

0

Thanks to Learning_DBAdmin for correcting me: the database does not have to be offline, the load process was failing due to remaining connections of other users on this target database. After killing the offending connections and putting the database in single user mode, it was possible to load a dump into it.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.