The Storage and Infrastructure Solutions Team is proud to publish Microsoft SQL Server 2008 Backup and Restore using Dell EqualLogic.

Download the paper here.

The goal of this paper is to describe best practices and reference architecture for performing traditional data backup operations of virtualized Microsoft SQL Server 2008® R2 databases running on Dell™ EqualLogic™ SAN using SQL Server Management Studio. The tests cases performed in this paper were specifically designed to find:

  • Best practices for backup target file layout - Impact of different backup target file layouts on backup performance .
  • Best practices for backup target volume layout – Impact of different backup target volume layouts on backup performance.
  • The impact of performing full, differential, transaction log backups, and full backup with compression on SQL server.