Current known limitations of SQL Clone
We're waiting for user feedback on how important these things are.
- The maximum size of an image (and therefore the maximum database size for cloning) is 2TB
- Databases with filestream and memory-optimized filegroups cannot be imaged
- Clones cannot be created on a SQL Server cluster
- CLR assemblies are not ported to other machines by SQL Clone. These may have to be registered in a post-clone step if they are required.
- SQL Clone does not currently support differential backups.
- Creating an image from a multi-database backup only creates an image for the first database in the backup.
Things to be aware of during the beta
- Progress indications are very inaccurate, just because the progress bar stops, it doesn't mean the operation won't succeed.
- It is likely there will be breaking changes during the beta program, requiring a full uninstall/reinstall of serverĀ and agents.
- If you delete or switch your configuration database, you must also cleanout of the %localappdata%\Red Gate\SQL Clone\clones directory manually.