Skip to Content
Jun 19, 2014 at 08:30 AM

MSSQL Server backup


Hi All,

I have a server with MSSql server 2008R2, i took a backup yesterday with recovery mode full and i have old backups they also with full recovery mode.

Now today due to some server issues i restored the Database with old backup not yesterday one with option RESTORE WITH NORECOVERY , now databse is in standby/Readonly mode. I dont have any Transaction log backups but have log in SIDlog folder .

How can i bring my Database to open/Readwrite state from standby/Readonly.

Please suggest me with your valuable opinions....

Thanks in advance


Praveen .