HP 3PAR Recovery Manager Software for Microsoft SQL Server Licenses User Manual
Page 10
How HP 3PAR VSS Software Works with Microsoft SQL Server
Figure 1 HP 3PAR VSS Provider Software for Microsoft Windows Operation Overview
1.
The requestor (HP 3PAR Recovery Manager) sends a command to the Volume Shadow Copy
service to take a shadow copy of the selected Microsoft SQL Server database.
2.
Volume Shadow Copy service communicates with SQL Writer on the Microsoft SQL Server to
flush the current log files to disk and suspend any writes to the transaction log files and to the
database file. However, HP 3PAR VSS Software allows read-only access so the client can
access any data that is already in the SQL Server database.
3.
Volume Shadow Copy service communicates with the provider to initiate the shadow copy
process for the disk volumes that contain the Microsoft SQL Server data.
4.
HP 3PAR VSS Software then communicates with the writers and providers to start creating the
shadow copy. The provider actually creates the shadow copy.
The shadow copy typically takes less than a minute.
5.
After the shadow copy is created, Volume Shadow Copy service communicates with the
Microsoft SQL Server with MSDE writer or SQL writer to indicate that it can resume writing to
disk.
6.
The queues of the SQL transactions are written to the logs.
The shadow copy is now available to the requestor for backing up.
10
Overview of Recovery Manager