Chrissy LeMaire shows how easy it is to create and manage database snapshots with dbatools:
New-DbaDbSnapshot
To create a new snapshot, you no longer need to know the path of the snapshot location (though we do support custom paths). You don’t even need to specify a name! But you can, of course.
| # Here’s how you create a snapshot for the HR and Accounting databases on server “sql2017” New-DbaDbSnapshot -SqlInstance sql2017 -Database HR, Accounting # Want it to be created in a specific path? New-DbaDbSnapshot -SqlInstance sql2017 -Database HR, Accounting -Path S:\snaps # Want to create snapshots on a bunch of different servers? # You can pass -SqlInstance $servers or you can pipe from Out-GridView in PS v5.1 and below! $servers | Get-DbaDatabase | Out-GridView -PassThru | New-DbaDbSnapshot
|
I haven’t used database snapshots in a while, but I do appreciate them, especially for testing scenarios.