SQL Server backups using SAN database snapshots

Thursday May 22nd 2008 by DatabaseJournal.com Staff
Share:

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.

[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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved