Using FlashArray Volume Snapshots with Microsoft SQL Server
FlashArray volume snapshots are an amazing tool for any DBA/DBRE managing SQL Server. You can use them to: Instantly recover from user errors or ransomware attacks Create rapid dev/test copies without full restores Offload CHECKDB to another host to avoid production performance hits Refresh reporting environments on demand Seed Always On availability groups faster, without large full backups Enable point-in-time recovery when paired with SQL log backups And the best part? Snapshots on FlashArray are: Immutable Space-efficient Fast to create and restore Fully automatable through the REST API or SDK tools! I worked very closely with our SQL Server field super stars (Anthony Nocentino, Andrew Pruski and Andrew Yun) on a white paper going VERY deep into the architecture and how to. It includes everything from crash- vs. application-consistent snapshots, to step-by-step restore and cloning procedures, to using SQL Server 2022’s new T-SQL snapshot backup. Did we miss anything ? Let us know!8Views1like0CommentsNew SQL Server with Pure Storage Reference Architecture!
We have a new SQL Server with Pure Storage Reference Architecture! It’s been out for a few months, but this is a great start to your journey to a simpler, high-performance database environment! This reference architecture shows how to: Consolidate transactional and analytical SQL Server workloads using FlashArray Use FlashBlade for rapid, parallel T-SQL backups to file or object storage Enable zero-downtime operations with ActiveCluster and near-synchronous replication via ActiveDR With this RA you will find detailed technical guidance for storage provisioning for SQL Server databases on Windows or Linux as well as best practice guidence on how to take the best advantage of the primary storage layer. Check out the full reference architecture here: Optimizing SQL Server Operations and Scale with Pure Storage (PDF) Have feedback, use cases to share, or questions about implementation? Please reach out!6Views1like0CommentsBackup and Restore FA Configuration
Hi All, Purestorage has how to save or backup and restore configuration when an issue occurs? For example, the software crashed and could not be used anymore. Once the problem was fixed, we restored the existing configuration file from backup.Solved125Views2likes6CommentsActiveCluster Asynchronous
Hello Having question about ActiveCluster Asynchronous is it possible to configure between 2 existing clusters Poland to Germany . Idea is to have ability to perform DR tests in Datacenters located in different country The customer is currently running a configuration based on X20R2/R4. They have two systems in the Poland and two in the Germany. Local replication between arrays is configured using ActiveCluster Synchronous. ################## Reviewed documentation is ActiveCluster over Fibre Channel and ActiveDR or Async is supported on the same system starting with Purity 6.1.3+. ActiveDR must be configured with separate volumes (and pods) from ActiveCluster volumes. ActiveCluster asynchronous works in such way that that both arrays Metro Arrays replicate data to 3d array protection group snapshot only Leveraging asynchronous replication is easy to do, it's a simple matter of defining a Target array in a Protection Group after connecting the array. Once defined in a Protection Group, the Protection Group itself can be moved into an ActiveCluster (our synchronous replication, RPO0 replication service) Pod, where the Protection Group is owned by two arrays. The defined Target can replicate regularly scheduled snapshots to a third array. This Active-Active Asynchronous Replication is shared by the ActiveCluster arrays and in the event that either array is offline, the alternate array will assume ownership of continual snapshot replication to the third array. In summary, you can replicate snapshots as desired between any number of arrays to any other number of arrays, requiring a defined array connection and Protection Group Target. These Protection Groups can also be moved into a pod for sharing between ActiveCluster arrays for disaster recovery purposes as well. The sequence of steps for enabling asynchronous replication: Connect arrays so the source and target arrays are aware of each other Create a Protection Group with desired snapshot policies Add any array to replicate snapshots to the Target field If using in an ActiveCluster pair, move the Protection Group into the ActiveCluster podSolved116Views1like3CommentsPurity FA 6.6.10* Introduces Better Data Security
Purity FA 6.6.10 introduces better data security by auditing file access. This means for all SMB and NFS shares, all access events can be captured and recorded to a local file or sent to a remote CIS log server. Check out the Pure Storage //Launch Round-Up for August! Have more questions? We’re all ears!31Views1like0CommentsAre you planning to implement vSphere 8 U1 on FlashArray?
Are you planning to implement vSphere 8 U1 on FlashArray? Why or why not? Have you heard? NVMe over Fabrics with VMware Virtual Volumes - “with VMware vSphere 8 U1, FlashArray is now validated with support for Virtual Volumes (vVols) when using NVMe over Fabrics (NVMe-oF) FC/TCP. Check it out here!16Views0likes0CommentsSelf-Service Upgrades = Full Control!
For those of you who have already tried Self-Service Upgrades (SSU) for FlashArray™, what were (are) the biggest challenges you encounter in managing your fleet’s upgrades? Whether you’re running multiple upgrades in parallel or just handling one at a time, it’s all in your hands! Check it out.18Views0likes0CommentsWhat’s the worst storage-related horror story you’ve encountered?
Pure Storage is redefining storage with capacity-optimized all-flash solutions. Say goodbye to compromising on speed or scalability! We’ve all had moments where slow storage caused an ‘uh-oh’ situation. What’s the worst storage-related horror story you’ve encountered? Check out this blog for all the details on how this innovation can power up your data infrastructure and more.18Views0likes0CommentsFlashArray//C20 - Innovation to the Edge
Are you looking to extend your storage capabilities to smaller, distributed environments without sacrificing reliability or performance? The wait is over. Pure Storage is taking innovation to the edge with the FlashArray//C20! Check out the details here! Do you have any follow up questions? Drop them below👇16Views0likes0Comments