beautypg.com

Backup and restore logs window – HP PolyServe Software User Manual

Page 24

background image

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 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.

Using MxMigrate

24