• I'm not familiar with Compellent, but I went to their web site. It looks to me like it's a SAN management and backup software. Is that right?

    If so, those things work really well. If you have giant databases on stand-alone systems, it's really one of the best ways to do backups and restores. However, if you have lots of small or mid-sized databases (< 1tb), getting snapshots of the drives, even if it is transaction aware snapshots (and that's the one thing you should validate) won't help you for restoring individual databases since multiple databases live on a drive. Personally, I'd see if you can't just do both.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning