Skip to Content
1:03:13 Webinare

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. Dezember 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.
  • Lösungen von Microsoft SQL und Exchange
  • Microsoft-Lösungen
  • 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.
Ihr Browser wird nicht mehr unterstützt!

Ältere Browser stellen häufig ein Sicherheitsrisiko dar. Um die bestmögliche Erfahrung bei der Nutzung unserer Website zu ermöglichen, führen Sie bitte ein Update auf einen dieser aktuellen Browser durch.