For this example the Adventure Works 2014 database is used to illustrate creating a VSS snapshot of the Data volume (Array1) and Log volume (Array2) on the two individual FlashArrays. As part of this test a new table is created, PointInTime, that inserts records continuously.
- Primary Data File (MDF) on F:\
- Log Data File (LDF) on G:\
Microsoft SQL Server Management Studio showing the Adventure Works 2014 database and the simple query to insert data.
USE AdventureWorks2014
GO
IF NOT EXISTS (SELECT name FROM sysobjects WHERE name = 'PointInTime' AND TYPE ='U')
CREATE TABLE PointInTime (PIT datetime)
WHILE ( 1 = 1 )
BEGIN
INSERT PointInTime SELECT GETDATE()
WAITFOR DELAY '00:00:001'
END