Dbcc file statistics

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No.

Any additional feedback? Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve?

Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. For information related to data security on cloned databases, see Understanding data security in cloned databases. Using this snapshot prevents blocking and concurrency problems when these commands are executed. As soon as the command has finished running, the internal snapshot is dropped.

Only the following objects can be cloned in the destination database. Encrypted objects get cloned but aren't usable in the clone database. Any objects that are not listed in the following section aren't supported in the clone:.

Natively compiled procedures are supported starting with SQL Server Query store data is copied only if it is enabled on the source database.

The following messages are an example of the messages logged in the error log during the cloning process:. The following example creates a clone of the AdventureWorks database that includes schema, statistics and query store data SQL Server The following example creates a clone of the AdventureWorks database that does not include statistics SQL Server The following example creates a clone of the AdventureWorks database that does not include statistics and query store data SQL Server