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

Using MxMigrate 20

Backup and Restore Databases Window

This window is used to back up the source databases and restore them on

the target server.

Start Backup. Click this button to start backing up the source SQL Server

database to a shared folder.

Start Restore. When the backup is complete, click Start Restore to begin

restoring the database to the target server.

Restore with RECOVERY on Target server. When this box is checked,

the databases will be restored with the Recovery option on the target

server. This option allows immediate access to the databases. The default

is NonRecovery, or unchecked.

NOTE: MxMigrate does a full database backup, which can invalidate

your existing SQL 2000 backup schedule. For example, you might

do a full backup at 12:00am and a differential backup every other

hour. If MxMigrate does its full backup at 10:30am, the next

differential backup will be based on this 10:30am backup. On SQL

2005, the

COPY_ONLY flag is used to ensure that your backup

strategy is intact. See SQL Book Online for details.