1. Yes, replication of SQL does work. One thing to keep in mind is that RepliStor will keep SQL crash consistent. The requirement for replicating SQL is to do both the *.MDF & *.LDF files.
3. Since RepliStor uses the Microsoft Shadow Copy Provider, it will have to take a snap of the entire volume. This is a Microsoft limitation with the provider. However, since ReplIStor provides a requestor, it only really snaps the Spec you have defined. Therefore, you will be able to see the entire structure of the drive, but you are only snapping the Spec data. The other file/folder structure you see are simply pointers.
4. I am not sure of what exactly you are asking here. But when you use VSS w/ SQL2005, the VSS routine will only do a snap of the SQL DB's when they are at a consistent state. If the snap is successful, the logs are truncated.
dramjass
151 Posts
0
February 21st, 2007 11:00
The requirement for replicating SQL is to do both the *.MDF & *.LDF files.
3. Since RepliStor uses the Microsoft Shadow Copy Provider, it will have to take a snap of the entire volume. This is a Microsoft limitation with the provider. However, since ReplIStor provides a requestor, it only really snaps the Spec you have defined. Therefore, you will be able to see the entire structure of the drive, but you are only snapping the Spec data. The other file/folder structure you see are simply pointers.
4. I am not sure of what exactly you are asking here. But when you use VSS w/ SQL2005, the VSS routine will only do a snap of the SQL DB's when they are at a consistent state. If the snap is successful, the logs are truncated.