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
  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.
  3. juniorsqldba New Member

    MohammedU,
    Appreciated your help. You are right, someone restore the databases, that is why it show STANDBY.[:D]
  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 ?

Share This Page