We are using snapshot replication as a standby to replicate prod data for a month from 2012 to 2008R2 after migration from 8R2 to 2012, just as a rollback process.
Using snapshot replication for 10 databases to replicate on old sql instance. For one of the db (2 TB) it takes almost 32 hours for distribution agent job to complete. On old sql that database is set to simple recovery model to prevent log growth and db there no needs to go through log backups. Snapshot job is scheduled to run daily 12 PM for a month or 2 to monitor for any issues on newly migrated one.
Is there a way this 32 hours can be made faster? Will changing to bulk recovery model help? Data type are blob and xml within that db ..