3.6.0 Migration Utility for SQL Server Operations Guide (5697-7090, December 2007)

Using MxMigrate 22

Create SQL jobs on Target server. Check the box to transfer 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.

Check the box to set 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

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.

Start Log Backup. Begin backing up the source server log to a shared

folder.