Category: SQL Server
view more software Tips and Tricks
Updated: 02/28/2017 17:02 PM
Author: Shiju Mathews
A database snapshot is a read-only, static view of a SQL Server database (the source database). The database snapshot is transactionally consistent with the source database as of the moment of the snapshot's creation. A database snapshot always resides on the same server instance as its source database. As the source database is updated, the database snapshot is updated. Therefore, the longer a database snapshot exists, the more likely it is to use up its available disk space. Multiple snapshots can exist on a given source database. Each database snapshot persists until it is explicitly dropped by the database owner.