HP Clustered Gateway Device Management Software manual Backup and Restore Logs window

Create SQL jobs on Target server. This option transfers SQL jobs from the source server to the target server. This box is checked by default.

Set Source DBs to read_only mode and terminate all user connections.This option sets the source database to read-only. Use this option only if you no longer want users to write to the source database. This option is valid for production migration. This box is unchecked by default.

To turn off policy checking for a login, execute the following command:

ALTER LOGIN <login_name> WITH CHECK_POLICY=OFF

GO

Backup and Restore Logs window

Use this window to back up the transaction log on the source server and restore it on the target server. Only databases with Full recovery mode can have transaction log backup. If the databases are not in Full recovery mode (i.e., simple or bulk), the databases will be skipped during the backup and restore phase.

Click Start Log Backup to begin backing up the source server log to a shared folder.

Click Start Log Restore to begin restoring the log to the target server.

24 Using MxMigrate