asked
My Database is on a SAN. I'm told that the SAN backups are sufficient. Is this true?
**ALL my Databases in Storage Area Network So can i take only SAN backups** IS it really possible real Time environment
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.
+1 for "make the SAN team show you a successful database restore". Until they've done that, take your own SQL backups as well.
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.
a good read on this topic. especially the performance hit you will face.
http://searchsqlserver.techtarget.com/tip/SQL-Server-backups-using-SAN-database-snapshots
16 People are following this question.
