It depends on a huge number of factors, but yes, it can be good enough in some situations. In some situations, it may be your only viable option. The best thing to do, in any circumstance like this, is to understand what the technology can and can't do, and ensure that the business agrees that the abilities you have for recovery are going to be adequate for them. If they are not, you may have to address this directly. It all goes back to establishing a Recovery Point Objective (literally, how much data can we lose) and a Recovery Time Objective (how long will it take us to recover). The RPO and RTO are not technical definitions, they're business definitions and you must have them in order to know which technologies you need.
Oh, and make the SAN team show you a successful database restore.
answered Oct 27, 2014 at 02:43 PM
Grant Fritchey ♦♦
No. You need native SQL backups for many reasons not the least of which is in case you need to restore only one database versus the whole LUN.
Don't believe the hype. You need backups.
answered Oct 27, 2014 at 01:48 PM