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

7. Confirm that the backup information file has been imported correctly.
On the database server (standby server), execute the drmsqlcat command.
PROMPT> drmsqlcat instance-name
8. Restore the user database.
On the database server (standby server), execute the drmsqlrestore command.
PROMPT> drmsqlrestore backup-ID -no_resync -nochk_host -target user-database-name
9. Recover the user database.
On the database server (standby server), execute the drmsqlrecovertool command.
PROMPT> drmsqlrecovertool instance-name
When the command is executed, the drmsqlrecovertool dialog box opens.
Specify the following conditions, and then click the Recovery button in the drmsqlrecovertool
dialog box.
• Click the Add button to select all the transaction log backup files.
• Select Loading for Recovery mode.
• Select Yes for Roll forward?.
10. Use a tool such as SQL Server Management Studio to create an AlwaysOn availability group
configuration for the database server (active and standby servers).
Restoring a user database to the secondary-use server from the active server
To restore a user database to the secondary-use server from the active server:
1. When the secondary-use server is set for the database server (active server), delete the AlwaysOn
availability group configuration for the secondary-use server.
2. Detach the user database on the secondary-use server (active server).
3. On the secondary-use server (active server), perform the following:
1. Stop the SQL Server instance.
2. Unmount the file system from the secondary volume.
3. Place the disk of the secondary volume offline.
Operation for SQL Server databases 398