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 de Dezembro de 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.
  • Soluções da Microsoft
  • FlashArray//X
  • Soluções Microsoft SQL e Exchange

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

* indicates a required field.

We hope you found this preview valuable. To continue watching this video please provide your information below.

Este site é protegido por reCAPTCHA, e se aplicam a Política de Privacidade e os Termos de Serviço do Google.

Seu navegador não é mais compatível.

Navegadores antigos normalmente representam riscos de segurança. Para oferecer a melhor experiência possível ao usar nosso site, atualize para qualquer um destes navegadores mais atualizados.

Personalize for Me
Steps Complete!
1
2
3
Thinking...