remains available. The following is a list of the most common prerequisites and limitations of
the source database:
- Database snapshots are supported only in the Enterprise version of SQL Server 2012.
- The source and the snapshot database must reside on the same SQL Server instance.
- The source database cannot be dropped, detached, or restored.
- Source database files cannot be dropped.
- Performance could be negatively affected due to increased I/O on the source.
The syntax script to create database snapshot
CREATE DATABASEON ( NAME = , FILENAME = ) AS SNAPSHOT OF
0 comments:
Post a Comment