In this recipe, we will drop an existing database snapshot.
Here are the steps to drop a database snapshot:
Open PowerShell ISE as an administrator.
Import the
SQLPSmodule and create a new SMO Server object as follows:#import SQL Server module Import-Module SQLPS –DisableNameChecking $instanceName = "localhost" $server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName
Add the following script and run it:
$databaseSnapshotName = "SnapshotDB_SS" #source database $db = $server.Databases[$databaseName] #for our recipe, drop snapshot if exists if($server.Databases[$databaseSnapshotName]) { $server.Databases[$databaseSnapshotName].Drop() }
Dropping a database snapshot using PowerShell and SMO is very similar to dropping an actual physical database. You need to create a handle in your database snapshot and use the Drop method:
$server.Databases[$databaseSnapshotName].Drop()