Restore and recovery

[valeriocicchiel]

Hello community,

I am new to SQL Server administration I have some Oracle knowledge, I have a (basic) question:

Can I restore an SQL database from a full single database (online) backup? Is this enough to open correctly the database, or a recovery from the transaction log backup is mandatory?

Regards, Valerio

[qingqingwang · Accepted solution]

hello,

Please check SAP note 1420452 point 4.

#1420452 FAQ: Restore and recovery with MS SQL Server

Kind regards,

Qingqing Wang

[Former Member]

Hi Valerio,

Full single database (online) backup is enough to open correctly the database and

recovery from the transaction log backup is not mandatory for SQL.

Is your os is windows?

If its windows , you need to follow the Note 551915 - R/3 won't start after database restore or database copy

R/3 wonu2019t start immediately after successful restoration ( @ windows and SQL).

Read the note and Down load the attachment from this note.

Use "user restore" script if you restore on same SID ( and you can use "user change" if you restore on different SID)

( you have to edit these script as per instructions)

Thanks & Regards,

Nagendra.

[valeriocicchiel]

Thanks for your help,

I admint I simply didn't check for SAP notes on this subject

Valerio