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