Code Samples

Create Snapshot

#  Check PowerShell Version
$PSVersionTable

#  Import Moodules
Import-Module PureStoragePowerShellSDK

# Create credentials
$Creds = Get-Credential

#  Create FlashArray object, endpoint, and use credentials
#  Connect to the FlashArray
$FlashArray = New-PfaArray -Endpoint 10.21.88.234 -Credentials $Creds -IgnoreCertificateError

#  Retrieve current Pure FlashArray disk numbers
Get-Disk | Where-Object FriendlyName -like "PURE*"

#  Retrieve current Pure FlashArray volume letters
Get-Volume | Select-Object DriveLetter, FileSystemLabel, Filesystem

#  Take Snapshot of specific volume
New-PfaVolumeSnapshots -Array $FlashArray -Sources '4-SQL-Data-Log' -suffix 'SNAP-1'

#  Create a new volumes from the snapshot
New-PfaVolume -Array $FlashArray -Source '4-SQL-Data-Log.SNAP-1' -VolumeName 'Demo-4-SQL-Data-Log-Copy-Vol-1'

#  Connect new volume copies to host
New-PfaHostVolumeConnection -HostName 'MARK-HOST-04' -Array $FlashArray -VolumeName 'Demo-4-SQL-Data-Log-Copy-Vol-1'

# Rescan Disks to ensure all are available in Windows
Update-HostStorageCache

#  Online Disks
Get-Disk | ? IsOffline | Set-Disk -IsOffline:$false

# Rescan Disks to ensure all are available in Windows
Update-HostStorageCache

# Rename Volume Copies
Set-Volume -DriveLetter D -NewFileSystemLabel '4-SQL-Data-Log-Copy-1'

Attach Database

USE [master]
GO
CREATE DATABASE [tpce-copy-1] ON
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\MSSQL_tpce_root.mdf' ),
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\TPCE_Log.ldf' ),
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\Fixed_1.ndf' ),
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\Fixed_2.ndf' ),
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\Fixed_3.ndf' ),
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\Scaling_1.ndf' ),
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\Scaling_2.ndf' ),
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\Scaling_3.ndf' ),
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\Growing_1.ndf' ),
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\Growing_2.ndf' ),
( FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\Growing_3.ndf' )
 FOR ATTACHGO

Drop Database

USE MASTER
go
ALTER DATABASE "tpce-copy-1"
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
DROP DATABASE "tpce-copy-1"GO

Delete Snapshot

#  Import Moodules
Import-Module PureStoragePowerShellSDK

# Create credentials
$Creds = Get-Credential

#  Create FlashArray object, endpoint, and use credentials
#  Connect to the FlashArray
$FlashArray = New-PfaArray -Endpoint 10.21.88.234 -Credentials $Creds -IgnoreCertificateError

#  Cleanup
#  Remove volume connections from the host
Remove-PfaHostVolumeConnection -HostName 'MARK-HOST-04' -Array $FlashArray -VolumeName 'Demo-4-SQL-Data-Log-Copy-Vol-1'

#  Remove Volume
Remove-PfaVolumeOrSnapshot -Array $FlashArray -Name 'Demo-4-SQL-Data-Log-Copy-Vol-1'
Remove-PfaVolumeOrSnapshot -Array $FlashArray -Name 'Demo-4-SQL-Data-Log-Copy-Vol-1' -Eradicate

#  Remove Snapshot
Remove-PfaVolumeOrSnapshot -Array $FlashArray -Name '4-SQL-Data-Log.SNAP-1'
Remove-PfaVolumeOrSnapshot -Array $FlashArray -Name '4-SQL-Data-Log.SNAP-1' -Eradicate

# Rescan Disks to ensure all are available in Windows
Update-HostStorageCache