What is database snapshot?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is database snapshot?

Rating:

Database snapshot is a read-only view of a database. It is taken from the source database and resides on the same server as the database. A snapshot uses a sparse file to store original pages from the source database. A sparse file is empty when a snapshot is taken. Whenever a page is changed in the source database, the Database Engine copies the original page to the sparse file in the snapshot before updating the page in the source database. The same process is repeated whenever a page of the source database is changed. The snapshot is used to recover data by reapplying the pages from the snapshot to the source database. Database snapshot is not available if its source database is disconnected for any reason.

Rating: