LHN-TAS-01.6 Microsoft SQL 2005 Backup and Restore VSS Snaps

LeftHand Networks Technical Application Series

TAS-01 VSS Scriptable Snapshots and the LeftHand SAN - SQL 2005 Backup and Restore
Part 6 of 6

Have you run Microsoft SQL Server 2005 in an iSCSI Storage Area Network (SAN) and wondered how to create a server-free backup policy through the use of hardware based snapshot leveraging Microsoft's VSS in order to provide consistent point in time snapshots. Every SQL Database Administrator and Storage Administrator should know how to leverage VSS snapshots in backup and restoration. This tutorial will guide a SQL Server 2005 Administrator to locating Database and Log files on separate iSCSI Volumes. Utilize the LeftHand Networks VSS Hardware provider to perform offhost volume snapshots which are application consistent point in time copies of data. Demonstration of Microsoft Access ODBC client access to data and data restoration demonstrations.

For Additional Information, http://www.lefthandnetworks.com or 1.866.4.IPSANS (866.447.7267)

Category:

Howto & Style

Tags:

• Technology
• Microsoft
• SQL
• 2005
• VSS
• Snapshot
• Backup
• Restore
• iS