Already on ArticleSlash?

Forgot your password? Sign Up

SQL Server Snapshot - How it Works


Visitors: 225

SQL Servers have been growing in business exponentially since they were created in the 1970's. First created by IBM in San Jose, California, SQL did not become a standard computer language until the mid-1980s. Since that time, during its growth, there have been many upgrades and changes to the SQL relational database management systems, one such upgrade is the SQL server snapshot.

A SQL server snapshot is essentially what it sounds like, it is a snapshot of the system that is stored and used as a primary system. When a snapshot occurs, the information is stored in the main drive and then further information created after the snapshot occurs is stored in a new data is stored in what is called a sparse file. A snapshot creates a backup of the system at that time, and uses 90% less drive space than backing up the system does. This information is stored for as long as the user requires it, and can be dropped when no longer needed.

The purposes of a SQL server snapshot vary depending on the needs of the user. In some cases, it is used simply to back up the system without having to use so much drive space during the working day. In other situations, it is created when data is perceived as “ideal" and any new data needs to be compared to the data that was previously acquired. This information can be stored indefinitely and new snapshots can be created at any point to continue tracking specific data. When saving the user should simply take the name of the data and add a time stamp to it. This will ensure that there is no confusion when accessing the information as to what its purpose is.

When a SQL server snapshot is dropped, the new information and the previous information join to form a completely new set of information. The information from the snapshot is no longer available and cannot be referenced for projects or projections. When the decision is made to drop it, it is vital that the project manager or user understands that it will become irretrievable.

While some business may never drop a SQL server snapshot, others may find that they simply want to test their data against studies that may have been conducted or to simply experiment with different ways of looking at their data. Once the information is retrieved the SQL snapshot is dropped in favor of new testing, or they return to their regular data consumption. Companies that track long-term data may never drop a snapshot, and the SQL servers are designed to function either way.

Source: Certdatabaseadministrator dot com, Louis Zhang

Get information about database administrator jobs , description, salary, certifications for SQL, Oracle and Microsoft at


Article Source:

Rate this Article: 
Leap Day Snapshot
Rated 4 / 5
based on 5 votes

Related Articles:

Sql Server Interview Questions on File Server and Client Server Database

by: Adam Sturo (April 25, 2007) 
(Computers and Technology)

Difference between VPS(Virtual Private Server) server and Dedicated Server.

by: Debasish Pramanik (February 25, 2015) 
(Internet and Businesses Online/Web Hosting)

About 70-458: Transition your MCTS on SQL Server 2008 to MCSA SQL Server 2012 ..

by: Jason S. Lawson (July 08, 2014) 
(Computers and Technology/Certification Tests)

70-457: Transition your MCTS on SQL server 2008 to MCSA: SQL server 2012 Part 1 .

by: Jason S. Lawson (July 08, 2014) 
(Computers and Technology/Certification Tests)

The Benefits of Cloud Server Technology over Traditional Server Hosting

by: Rahul Gupta (April 18, 2012) 
(Internet and Businesses Online/Web Hosting)

SQL Server Compare and SQL Server Migration - Make your Life Easier

by: Daniel Zr (April 24, 2011) 
(Internet and Businesses Online/Web Development)

How to Avoid Server Performance bottleneck in Oracle Database Server

by: Gitesh Trivedi (July 23, 2012) 
(Computers and Technology/Software)

Cardsharing Server and CCcam server, a Revolution to the Satellite TV

by: Shovon Joarder (August 23, 2015) 

How to Get the 70-646 Windows Server 2008, Server Administrator Credential

by: George S. Niles (June 26, 2014) 
(Computers and Technology/Certification Tests)

Leap Day Snapshot

by: Otto King (February 29, 2008)