Hi,
We are experiencing problems with synchronizing our production and test environment. The DB in the production environment is apprx. 40+ gb and making a backup and restoring it is causing many problems, replication is also not a viable option as it does not cater for our situation.
Is there any other way of synchronising the databases with minimal downtime. Any feedback will be appreciated.