We are running SQL Server on ec2 and have assembled a Storage Space from multiple EBS volumes to hold the databases. This has been working better than we'd anticipated. But I'd like to explore snapshot-based backups and this leads to my question.
Is is possible to assemble a Storage Pool from its constituent disks and have the data remain in tact? For my particulars, I want to be able to do something like the following:
- Quiesce database writes (I think I've got a good tool for this).
- Snapshot the individual ebs volumes that make up the Storage Pool that holds the data.
- Present those snapshots to a different server.
- Assemble a storage pool out of those disks, preserving the virtual disk and its data.
- Attach the databases.
I don't even know where to begin searching for this.