Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    21

    Unanswered: best way to make db unavailable

    We are migrating a db from one server to another.
    What is the best way that Sybase has to offer to lock out users?
    We want to make sure that the users do not connect to the wrong db, but we need this method to be easily reversed if a rollback to the orginal server was needed.

    Thanks,
    Ova

  2. #2
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120
    With

    sp_dboption mydb, 'dbo use only', true

    can a database made accessible only for the dbo, which is normally the sa.
    This should be sufficient for your task.

    It can be reverted with

    sp_dboption mydb, 'dbo use only', false

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •