Skip to Content
1:03:13 Webinars

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.
This webinar first aired on 1 december 2022
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-oplossingen
  • Microsoft-oplossingen
  • FlashArray//X

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:

  • Why and how to use snapshots
  • How to simplify complex workflows with snapshots
  • How to easily replicate a snapshot to Dev/Test environments
  • How to create and manage snapshots with T-SQL
  • How to utilize PowerShell SDKs to extend functionality

And more…

Continue Watching
We hope you found this preview valuable. To continue watching this video please provide your information below.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Uw browser wordt niet langer ondersteund!

Oudere browsers vormen vaak een veiligheidsrisico. Om de best mogelijke ervaring te bieden bij het gebruik van onze site, dient u te updaten naar een van deze nieuwste browsers.