David Egnoski (4/27/2011)
Thank you for the reply, Grant. Compellent is SAN management and backup software. It is not transaction aware. I've been told by one of their customers that they set every database to simple recovery.As we have many small databases (<= 2GB), on a single drive, you are correct that this technology doesn't help much with single database restores. An entire drive would be restored and I would have to detach and then attach the database that I need restored.
I'm voting to keep Redgate.
Yeah, if it's not transaction aware then there's no way in the world I would support using it as a means of backing up my database systems. That has nothing to do with keeping Red Gate or not. You need to know that when you restore the drive that the databases on it won't be corrupt, that committed transactions are written to disk and uncommitted transactions are rolled back. That's also completely independent of whether or not your database is in simple recovery mode (you might want to to talk to them and their customers, they're operating in a dangerous manner).
"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