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

Question

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

Answer 1

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

Answer 2

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.

Answer 3

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

Code Block

Restore database dbname with recovery

 

 

- Deepak

Answer 4

Hi,

 

Try the below command also

ALTER DATABASE database_name ONLINE

Answer 5

Hi,

 

You can try this, it worked for me-

RESTORE DATABASE <db_name> WITH RECOVERY

Answer 6

HI There I used restore database <DBNAME> with recovery

works for me.

Answer 7

Hi,

RESTORE DATABASE <db_name> WITH RECOVERY

This works just fine.. Thanks..