Compellent Power-Shell Scripting
I recently attended the first Nashville Area Compellent User Group hosted at Thompson Machinery. It was a great meeting with Jeff Lamothe of Compellent presenting the upcoming features and enhancements to the Storage Center line. Thanks also to Greg Horsley and Whit Linder for putting this together and buying us the fish dinner!
I also was allowed to make a presentation (yeah me!) about Power-Shell scripting we recently did at my company to help manage our QA and development MS SQL Server environments with the Compellent StorageCenter array. The script is fairly simple, but works very well for us. It uses a configuration file to link Compellent volume names to mount paths. It uses the volume names to present a list of available replay dates to select. Once the replay is selected the magic happens!
- It stops the services listed in the file
- Unmounts and destroys the previous replay views
- Creates the new replay views and assigns the volume mappings
- And finally restarts the services
If all is configured correctly from start to finish you can refresh a sandbox system with a replay from a production system in less than 5 minutes. Our DBAs love this!
You can download the script and presentation I made here : Compellent PowerShell – Mount Replays
