Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    42

    Unanswered: How to put db in read only state

    This is probably a FAQ question but I cannot find the answer.

    To minimize the effect of downtime during maintanance window I would like to put the DB into read-only state. What is the way to do that?

    Thank you in advance.

    Alexander.

  2. #2
    Join Date
    Aug 2004
    Posts
    138
    SET--WRITE--+-SUSPEND-+--FOR--+-DATABASE-+------------------><
    '-RESUME--' '-DB-------'


    Command Parameters
    SUSPEND
    Suspending I/O writes will put all table spaces into a new state SUSPEND_WRITE state. Writes to the logs are also suspended by this command. All database operations, apart from online backup and restore, should function normally while database writes are suspended. However, some operations can wait while attempting to flush dirty pages from the buffer pool or log buffers to the logs. These operations will resume normally once the database writes are resumed.

Posting Permissions

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