question

UnishSQL avatar image
UnishSQL 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
sql-server-2008sql-server-2008-r2databasebackupsan
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
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.
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

+1 for "make the SAN team show you a successful database restore". Until they've done that, take your own SQL backups as well.
2 Likes 2 ·
ya same question was asked by me.....and thank u for info
0 Likes 0 ·
SQLGoooRooo avatar image
SQLGoooRooo answered
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.
4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
0 Likes 0 ·
thnks for the info
0 Likes 0 ·
I am on the no side, regardless.
0 Likes 0 ·
now iam also on the no side @raadee
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.