How can I get a database out of Standby/Read-only mode?

Wed, 16 Jan 2008 17:43:23 Z

How can I get a SQL Server 2005 database out of Standby/Read-only mode? I just restored this DB sent from a customer and it is in Standby/Read-only mode. I need to add a user so that I can authenticate from my app for testing purpose.

Thx

How can I get a database out of Standby/Read-only mode?

Wed, 16 Jan 2008 18:12:10 Z

Hi jdub3!

To get the database out of STANDBY mode after the restore, you must restore the database WITH RECOVERY.

Code Block
RESTORE DATABASE <database_name> FROM <full_backup>
    WITH RECOVERY;

This will make the database available for use - it is in read-only mode while in standby mode.

Brian

How can I get a database out of Standby/Read-only mode?

Wed, 16 Jan 2008 18:33:46 Z

Doah! I had tried this earlier but it wasn't working. It turns out that I created my DB with the wrong name (missed a letter my eyes weren't catching even though I looked). My SQL statement used the name it was supposed to be, but wasn't, hence it kept failing.

I win the idiot for the day award. Thanks for the help as I wouldn't have tried this again otherwise.

How can I get a database out of Standby/Read-only mode?

Wed, 16 Jan 2008 18:42:37 Z

You can use this as well to bring the database online from standby\read-only mode

Code Block

Restore database dbname with recovery

- Deepak

How can I get a database out of Standby/Read-only mode?

Thu, 17 Jan 2008 19:16:45 Z

Hi,

Try the below command also

ALTER DATABASE database_name ONLINE

How can I get a database out of Standby/Read-only mode?

Wed, 12 Nov 2008 05:35:59 Z

Hi,

You can try this, it worked for me-

RESTORE DATABASE <db_name> WITH RECOVERY