Other applications of NetBackup for SQL Server Performing backups and restores in an SAP environment
Replace damaged disks.
Replacing damaged disks in a RAID disk system is normally a straightforward procedure. If you are uncertain how to proceed, refer to the documentation of your hardware vendor to find out how to handle the disks. The new disks must be formatted and assigned the same drive letter as the old disks.
Restore the database and transaction logs.
The central phase of a restore operation is the reloading of the database backup and the application of the available transaction logs. When the database backup is reloaded, the database files are automatically recreated and the data is copied from the backup device to the newly created files. Once this has been done, the transaction logs are applied in the same sequence as they were originally made. In a final step, open transactions that were not completed at the time of the database failure are rolled back.
Restoring the database 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 along with any optional differential backups and subsequent transaction log backups. There is also 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 attempting a restore using NetBackup.
Caution: 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 and transaction log backups
1 2 3 4
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.