How to make database read-write

mailguy

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

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 <my_database> 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

mailguy

Thanks. That worked.