SQL Clone Test Environment

• 
  Would it be possible to see your script?  I'm curious why it deleted all clones.

  behibberd January 28, 2020 20:56

  - 0 +
• 
  Sure!
  ________________________________________________________________________________
  

  Param($ImageName) 

  
  

  Connect-SqlClone -ServerUrl 'http://clone.server:14145'

  
  

  $image = Get-SqlCloneImage -Name $ImageName

   

  $clones = Get-SqlClone -Image $image

   

  $elapsed = [System.Diagnostics.Stopwatch]::StartNew()

   

  "Started at {0}, removing {1} clones for image ""{2}""" -f $(get-date) , $clones.Count , $image.Name

   

  $clones | foreach { # note - '{' needs to be on same line as 'foreach' !

      $_ | Remove-SqlClone | Wait-SqlCloneOperation

      "Removed clone ""{0}""" -f $_.Name ;

                      };

  "Total Elapsed Time: {0}" -f $($elapsed.Elapsed.ToString())
  
  _______________________________________________________________________________

  DavidWNAZ January 28, 2020 21:11

  - 0 +
• 
  Thanks!  Two ideas for you:
  
  

  1. If you pass in an invalid image name, an error is generated.  You can start the script with an $ErrorActionPreference = 'Stop', which will stop the script on the first error.
  2. Right now, Get-SqlCloneImage is generating an error and setting $image to $null.  If you pass in $null for the -Image parameter to Get-SqlClone, Get-SqlClone will return all of the clones, which is the behavior you're seeing.  You can do an if ($null -eq $image) { return } right after the call to Get-SqlCloneImage, which will also save you from grabbing all the clones.

  behibberd January 28, 2020 21:28

  - 0 +
• 
  Thanks for the input.  I'll include that once I get a test environment configured.  Still waiting for an answer on that.  I'm still relatively new to PS, so thanks for the tips!

  DavidWNAZ January 28, 2020 21:34

  - 0 +

Add comment

Please sign in to leave a comment.