Home / Software / Tips and Tricks / What is SQL server Database Snapshots?

What is SQL server Database Snapshots?

Updated:  02/28/2017 17:02 PM
Author:  Shiju Mathews

Status:    Resolved.


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.