Deleting backup data – HP Serveur lame HP ProLiant BL465c Gen8 User Manual
Page 383
To restore (recover) backup data from tape to the secondary volume:
1.
Execute
EX_DRM_TAPE_RESTORE
to restore the SQL Server database from tape to the secondary
volume.
2.
Execute the
drmsqlcat
command with
instA
specified to check the backup ID.
3.
Execute the
drmsqlrestore
command with
instB
specified as the
-instance
argument to
restore the SQL Server database on the secondary volume.
4.
Execute the
drmsqlrecover
command or
drmsqlrecovertool
command with
instB
specified to recover the SQL Server database.
Example of restoring (recovering) an SQL Server database on the log distribution destination
An example of restoring (recovering) an SQL Server database on the secondary volume is described
below.
To recover on the secondary volume:
1.
If the backup catalog was not imported at the time of backup, execute the
drmdbimport
command to import the backup catalog.
2.
Execute the
drmsqlcat
command with
instA
specified to check the backup ID.
3.
Execute the
drmsqlrestore
command with
instB
specified as the
-instance
argument to
restore the SQL Server database on the secondary volume.
4.
Execute the
drmsqlrecover
command or
drmsqlrecovertool
command with
instB
specified to recover the SQL Server database.
Example of restoring (recovering) an SQL Server database on the primary volume
An example of restoring (recovering) an SQL Server database on the primary volume is described
below.
To restore (recover) data on the primary volume:
1.
If there is no data to restore (recover) on the secondary volume, restore the SQL Server database
to the secondary volume by conventional procedures.
2.
Execute the
drmsqlrestore
command with
instB
specified as the
-instance
argument to
restore the SQL Server database from the secondary volume to the primary volume.
3.
Execute the
drmsqlrecover
command or
drmsqlrecovertool
command with
instB
specified to recover the SQL Server database.
Deleting backup data
If the backup data in the secondary volume is no longer necessary, you may delete it. Backup data
is deleted after being backed up from the secondary volume to tape, or restored from the secondary
volume to the primary volume.
To delete the backup data:
Application Agent CLI User Guide
383