SQL Server Performance

Why the database show "(Standby / Read-only)"

Discussion in 'Getting Started' started by juniorsqldba, Jan 19, 2008.

  1. juniorsqldba New Member

    Hi everyone,
    Recently I found several databases in one databases server show status "Standby / Read-only". May I know why the database being set to this status?
    I'm newbie in Ms SQL Server.
    Regards,
    Jimmy Liew
    juniorsqldba, Jan 19, 2008
    #2

  2. MohammedU New Member

    May be some one restored the databases with STANDBY option OR some one might have updated the sysdatabases if it is sql 2000.
    MohammedU, Jan 19, 2008
    #3

  3. juniorsqldba New Member

    MohammedU,
    Appreciated your help. You are right, someone restore the databases, that is why it show STANDBY.[:D]
    juniorsqldba, Jan 20, 2008
    #4

  4. exprof New Member

    Now,
    1. if we want to perform DML on this database then how to remove this database mode/state ?
    2. Alter database read-write Go ....... database state option .. read-only from false to true is not working.
    How to make such DB live ?
    exprof, Jun 18, 2008
    #5

Share This Page