On Twitter, several SAN pros were saying their snapshots can pull off some nifty stuff. Well, it’s time to find out just how true that is.
Let’s say we have a data warehouse with:
- One 2TB database, using SQL Server partitioning – needs 8 data files and 1 log file
- One 200GB database for reporting – has 1 data file and 1 log file
- 5 smaller 20GB configuration databases – each with 1 data file and 1 log file
- TempDB – eight data files and one log file
My business needs for backups are:
- Back up any of the databases individually, at any time, with snapshots
- Back up the 5 smaller 20GB databases with transaction log point-in-time recovery abilities
- Sync any of the databases over the WAN to a second SAN
- Be able to restore any of the databases individually to the snapshot, and be able to restore any of the smaller databases to a point in time
The question is:
- How many LUNs do I need to accomplish that goal?
- Is the backup process completely automated without scripting? (Meaning, if the customer has to roll their own scripts, is there any examples you can point to?)
- What makes/models of the SAN support it?
If your SAN can do it, I’d love to hear about it. You can email me directly, or post the responses here in comments.