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

4. After the pair status of the Continuous Access Software pair volume is changed to PAIR , perform
takeover.
To perform takeover, execute the RAID Manager command at the remote site.
PROMPT> paircreate -g TC01 -vr ( or pairresync -g TC01 )
PROMPT> pairevtwait -g TC01 -t 600 -s pair
PROMPT> horctakeover -g TC01
5. Mount the Continuous Access Software pair volume at the remote site and restart SQL Server.
The mount point name to mount must be same as the mount point name at the local site. Perform
operations in step 5 at the remote site.
6. Attach the database from the mounted disk to check the database ID.
Check the database ID at the remote site:
PROMPT> osql -E
1> SELECT DB_ID("UserDB1")
2> go
If the database ID at the remote site is not the same as the database ID at the local site checked
in step 2, set the database ID at the remote site to the same database ID as one at the local site.
7. Stop the SQL Server service and unmount the Continuous Access Software pair volume.
Perform operations in step 7 at the remote site.
8. Perform takeover.
To perform takeover, execute the RAID Manager horctakeover command at the remote site:
PROMPT> horctakeover -g TC11
9. Mount the Continuous Access Software pair volume at the local site and start the SQL Server
service.
10. Create a database configuration definition file.
To create a database configuration definition file, execute the drmsqlinit command on the
database server at the local site.
PROMPT> drmsqlinit default
KAVX1100-I Enter the name of the storage directory for VDI metafiles:
KAVX1101-I Enter the timeout interval for VDI generation (in seconds, between 0 and 3600): 300
KAVX1102-I Enter the name of the storage directory for undo files: E:\MSSQL\DEFAULT\undo
KAVX1107-I Enter the name of the directory that contains the backup logs: E:\MSSQL\DEFAULT\tlog
KAVX1103-I SQL Server information has been updated.
11. Update the dictionary map files.
To update the dictionary map files, execute the drmsqldisplay command on the database
server at the local site.
PROMPT> drmsqldisplay -refresh
KAVX0023-I Dictionary map file was updated.
Operation for SQL Server databases 354