Dropping a database snapshot
In this recipe, we will drop an existing database snapshot.
How to do it...
Here are the steps to drop a database snapshot:
Open PowerShell ISE as an administrator.
Import the
SQLPS
module 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() }
How it works...
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()
See also
The Listing...