How can we help you today? How can we help you today?

How to make database read-write

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
mailguy
0

Comments

2 comments

Sort by
  • Jason Cook
    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
    Jason Cook
    0
  • mailguy
    Thanks. That worked.
    mailguy
    0

Add comment

Please sign in to leave a comment.