Pure Storage, Inc.
SQL Server Native Backup and Restore with FlashArray
Pages
9
Time to read
20 mins
Publication
Language
English
Pages
9
Time to read
20 mins
Publication
Language
English
This white paper presents an in-depth examination of using Everpure FlashArray as a native backup and restore solution for SQL Server environments. It outlines the challenges faced by traditional disk-based backup systems, particularly as SQL Server databases expand and recovery time expectations increase. The paper introduces FlashArray as a flexible, all-flash platform that enhances backup performance and reliability while simplifying administration. It details the solution architecture, emphasizing the integration of FlashArray with SQL Server's native backup capabilities. The document also discusses critical factors affecting backup and restore performance, including thread usage, parallelism, and the impact of network configurations. Additionally, it provides specifications of the validation environment used to test performance, highlighting the configuration of FlashArray devices and SQL Server instances. The findings illustrate how FlashArray can serve as an effective replacement for existing disk-based appliances, improving overall backup and restore operations.