The Advantages of SQL Server Snapshots

Name: The Advantages of SQL Server Snapshots
Uploaded: 2022-12-07T06:14:50.000-07:00
Duration: 1 h 3 min 13 s
Description: Database snapshots are a great feature of SQL Server that are often underutilized. This feature of SQL Server allows for the instant creation of a point-in-time copy of a database that can then be used for several purposes such as reporting, auditing, refreshing Dev and Test environments, etc.

This webinar first aired on 2022년 12월 1일 (목)

The first 5 minute(s) of our recorded Webinars are open; however, if you are enjoying them, we’ll ask for a little information to finish watching.

Microsoft SQL & Exchange 솔루션
FlashArray//X
Microsoft 솔루션

Robert Quimbey

Senior Solutions Architect, Microsoft • FA Product Management, Pure Storage

The Advantages of SQL Server Snapshots:

Database snapshots are a great feature of SQL Server that are often underutilized. This feature of SQL Server allows for the instant creation of a point-in-time copy of a database that can then be used for several purposes such as reporting, auditing, refreshing Dev and Test environments, etc. At the point of creation, the snapshot is a read-only static view of the database, but a database snapshot also allows for data modifications that won’t affect the database from which the snapshot was created.

In addition, SQL Server has the ability to execute snapshots at a granularity level not possible with the Volume Shadow Copy Service (VSS), so snapshots are definitely a feature you should be using in your environment.

Come join us to learn: