This section describes
how to prepare to migrate your SQL Server databases
so that you can manage backup and restore operations using SnapManager.
While preparing to migrate your databases, note the following:
- Secondary Availability Group database migration creates a stream-based backup in
the SnapInfo folder.
- During a secondary database migration, there should not
be any backups made on any node for that database.
- During
primary database migration, secondary databases are also affected, so it is
best not to perform any operation on the database until the migration completes.
- For all
replicas wherever SnapManager is being used, Readable Secondary
values should be set to Yes.
- Concurrent migration on different replicas of
the same Availability Group at the same time is not advisable.
- During secondary database
migration, the old database files are removed regardless of
the value of the setting, Delete old database files after migration.