Last Restration

[Former Member]

How to check , when the last restoration done through SAP in oracle database.

[Former Member · Accepted solution]

Hi,

You can get this information from the restoration logs in the SAPBackup folder. The restoration log file will be of the format <filename>.rsb.

Hope this helps.

Regards,

Varadharajan M

[Former Member]

Hi, if for restoration are used any external programm (like full backup of your datafiles using Data protector or other tools) you only can check log's generated by this programms. If you use the BRRESTORE or BRRECOVERY for this try to check log's in sapbackup directory .

P.S. from sap you can check in DB14 transaction.

Regards.

[Former Member]

How to check the same in MS SQL 2000

[Former Member]

How to check the same in MS SQL 2000

[Former Member]

In same DB14 you can Check the log files.

Otherwise, check the log from BRtools.

[Former Member]

Hi

for MS SQL DB12>Backup and Recovery>Restore History.

Here you will find detailed list of all restores performed on the database.

Thanks

Mushtaq

[Former Member]

Sorry luckshmanan

DB14 does not work in SQL 2000

[Former Member]

Mushtaq ,

that is for master and model database .......iwnat to know about the full database restoration

[Former Member]

Can you please check it, i checked and i am sure that it shows restore history of your SAP 'SID' database.

if not you can also run this script against your database:

USE MSDB 
GO 

SELECT *
FROM RESTOREHISTORY WITH (NOLOCK)
WHERE (DESTINATION_DATABASE_NAME = 'Change_me')
ORDER BY RESTORE_DATE DESC

Thanks

Mushtaq