vegeta1138
IS-IT--Management
- Jan 20, 2008
- 4
- 0
- 0
We have an EMC CX3-10c that hosts our SQL Database. There are 3 Luns. One contains the log (ldf) file, the second contains the primary file group and the third the secondary file group.
Every night we run the following admsnap in a batch file via Windows Scheduled Tasks:
admsnap stop -s LogFile-o j:
admsnap flush -o j:
admsnap start -s LogFile-o j:
admsnap stop -s PrimaryFileGroup-o i:
admsnap flush -o i:
admsnap start -s PrimaryFileGroup-o i:
admsnap stop -s SecondaryFileGropu-o h:
admsnap flush -o h:
admsnap start -s SecondaryFileGroup-o h:
My question is this: If we find ourselves in the unfortunate position of having to do a rollback, will the data be consistent? My concern is that since the log file and database file are so interdependent that the snapshots won't occur in parallel and thus the snapshot would be virtually useless.
The example I' thinking of is that the log LUN is snapped and then a record is inserted then the DB and then the DB lun is snapped.
Is this a valid concern? If so what options (with admsnap) to we have?
Many thanks,
Every night we run the following admsnap in a batch file via Windows Scheduled Tasks:
admsnap stop -s LogFile-o j:
admsnap flush -o j:
admsnap start -s LogFile-o j:
admsnap stop -s PrimaryFileGroup-o i:
admsnap flush -o i:
admsnap start -s PrimaryFileGroup-o i:
admsnap stop -s SecondaryFileGropu-o h:
admsnap flush -o h:
admsnap start -s SecondaryFileGroup-o h:
My question is this: If we find ourselves in the unfortunate position of having to do a rollback, will the data be consistent? My concern is that since the log file and database file are so interdependent that the snapshots won't occur in parallel and thus the snapshot would be virtually useless.
The example I' thinking of is that the log LUN is snapped and then a record is inserted then the DB and then the DB lun is snapped.
Is this a valid concern? If so what options (with admsnap) to we have?
Many thanks,
