You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 13
Next »
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 differential backup.
- 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.
Known issues
- Progress indications for creating images from backups are very inaccurate.
- When creating an image from a multi-database backup, only the first database within the backup will be imaged.
Untested scenarios