Restoring the database backups and transaction
log backups
NetBackup MS-SQL server
agent GUI provides for automatic staging. By selecting the latest
transaction log backup, the GUI automatically restores the previous
full database backup. It also restores any optional differential
backups and subsequent transaction log backups. You can also use
the option to specify a point in time to which to restore to.
Note:
|
The
R3 database must not be in use when performing a restore operation.
Make sure that all SAP services are stopped before you attempt a
restore with NetBackup.
|
Warning:
|
To
restore the R/3 database you first restore the most recent database
backup and then the subsequent transaction logs. During the entire
procedure, do not execute any transactions and do not shut down the
database server. A server shutdown would write a checkpoint to the
log and as a result you would not be able to restore further
transaction logs.
|
To restore the database backups and transaction
log backups
-
Restore the most recent
database backup.
-
Restore the latest
differential database backup (if available).
-
Restore all succeeding
transaction log backups.
-
Restore the latest
transaction log backup.