MSSQL Server backup

[Former Member]

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 .

[former_member188883 · Accepted solution]

Hi Praveen,

Please restore it again using latest full backup using option restore with recovery.

For the option you selected you need to provide log files to recover without which you cannot make the database up and running.

Refer to restore and recovery steps from the link below

http://msdn.microsoft.com/en-IN/library/ms179451.aspx

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

Thanks for your suggestion.I was trying that option but i am not getting option to restore the database again, Database restore option is disabled , i am trying with the sql visual studio.

Please suggest me if is there any other way to restore.

[former_member188883 · Accepted solution]

Hi Praveen,

Please to refer to below SAP notes for options in system copy process.

You can use MSSQL tool to perform the system copy

Note 151603 - Copying an SQL Server database

Also refer to SAP note for Post copy steps.

Note 683447 - SAP Tools for MS SQL Server

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

Its worked for me , Thanks alot.

[former_member188883 · Accepted solution]

Hi Praveen,

Good to know problem is resolved. please close this thread.

Regards,

Deepak Kori