HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 374)

10. From the database server, obtain the temporary file that was exported on the backup server.
Obtain the temporary file C:\FTP_ROOT\EX-FILE1.drm , which was exported on the backup
server, from the database server at the remote site. Use the ftp (file transfer protocol) command
to obtain the temporary file C:\FTP_ROOT\EX-FILE1.drm (created in step 9) to the database
server. The temporary file will be stored in the current directory. The following assumes that the
current directory is
C:\ .
PROMPT> ftp backup-server-name
ftp> Username: (Enter the login name)
ftp> password: (Enter the password)
ftp> binary
ftp> get EX-FILE1.drm
ftp> quit
PROMPT>
11. Import the temporary file into the backup catalog on the database server.
To import the temporary file C:\EX-FILE1.drm (transferred from the backup server in step 10)
into the backup catalog on the database server, execute the drmdbimport command on the
database server of the remote site.
PROMPT> drmdbimport -f C:\EX-FILE1.drm
KAVX0001-I The drmdbimport command will now start.
KAVX0418-I Backup information from the specified file was imported into the backup catalog.
Imported backup ID = 0000000002
KAVX0002-I The drmdbimport command will now end.
PROMPT>
At a restoration, backup information is registered in the backup catalog of the database server
under the new backup ID
0000000002 . Also, since the fact that a restoration was performed
from tape to the secondary volume is reflected in the backup catalog, the backup ID 0000000001 ,
which was used to manage the status of the secondary volume before the update, is deleted from
the backup catalog on the database server.
12. Check the backup catalog for the copy group to be used for restoration.
Execute the drmsqlcat command on the database server at the remote site.
PROMPT> drmsqlcat default -template
INSTANCE: default
BACKUP-ID: 0000000002 BACKUP-MODE: ONLINE INSTANCE: default ORIGINAL-ID: 0000000001
START-TIME: 04.02.04 13:01:35 END-TIME: 04.02.04 13:02:33 HOSTNAME: flora4
T DB OBJECT FILE FS DG DEVICE COPY-GROUP
M UserDB1 METAFILE O:\MSSQL\0000000002_0000000001.dmp - - - -
D UserDB1 DATAFILE O:\UserDB1_Data.MDF O: - Harddisk4
SI12,sql01
- - - - - - -
SI12,sql01
T UserDB1 TRANSACT O:\UserDB1_Log.LDF O: - Harddisk4
SI12,sql01
- - - - - - -
SI12,sql01
13. On the remote site, mount the primary volume.
14. On the remote site, start the SQL Server service.
Operation for SQL Server databases 374