SQL Server backups using SAN database snapshots

May 22, 2008

[From Search SQL Server]

One of the toughest things about managing a big database is the backup window: The bigger a database gets, the longer SQL Server backups take. Ironically, larger databases like data warehouses are also the ones that want the smallest nightly maintenance windows because they're desperate for more time to load the data.

Storage area network (SAN) database snapshots give DBAs the ability to bypass the backup window altogether and perform backups inside the SAN instead of doing it at the operating system level.

The article continues at http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1314693,00.html