In order to help prioritize our development, please let us know if anything on this page is a barrier to using SQL Clone.
Current known limitations of SQL Clone
- The source of an image cannot:
- Have a total combined file size (mdf+ldf) of over 2TB.
- Contain filestream or memory-optimized tables/filegroups.
- Be a SQL Server database snapshot.
- Be a live database currently part of a failover cluster.
- Images can be created using backups of such a database.
- Images can be created from availability groups.
Clones cannot be created into failover clusters or availability groups.
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.
- Progress indications for creating images from Redgate SQL Backup files are very inaccurate.
- When creating an image from a multi-database backup, only the first database within the backup will be imaged.