How to make database read-write

mailguymailguy Posts: 5
edited September 21, 2007 10:04PM in SQL Backup Previous Versions
I hate to ask, but I'm not a DBA. We log ship to a backup database server. This backup database is in Standby / read-only mode. How do I make this database fully active again - ie not in standby mode. I know this will break the log shipping process, but need to do this for now. I think I use the ALTER database command, but not sure about which options.


Thanks in advance

Comments

  • To bring the database out of a standby or read-only state into an operational state, you need to execute the following (substituting in <my_database> as appropriate)
    RESTORE DATABASE &lt;my_database&gt; WITH RECOVERY
    

    While this is part of the "RESTORE DATABASE" command, it will not perform any more restores, just bring the database online.

    Hope that helps,
    Jason
  • Thanks. That worked.
Sign In or Register to comment.