x

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

more ▼

asked Oct 27, 2014 at 01:39 PM in Default

avatar image

UnishSQL
419 5 10 20

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Oct 27, 2014 at 02:43 PM

avatar image

Grant Fritchey ♦♦
137k 20 44 81

  • for "make the SAN team show you a successful database restore".

Until they've done that, take your own SQL backups as well.

Oct 27, 2014 at 02:53 PM ThomasRushton ♦♦

ya same question was asked by me.....and thank u for info

Oct 28, 2014 at 05:37 AM UnishSQL
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Oct 27, 2014 at 01:48 PM

avatar image

SQLGoooRooo
241 1 3 6

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

Oct 27, 2014 at 01:50 PM SQLGoooRooo

thnks for the info

Oct 28, 2014 at 05:37 AM UnishSQL

I am on the no side, regardless.

Oct 28, 2014 at 09:25 AM raadee

now iam also on the no side @raadee

Oct 28, 2014 at 10:16 AM UnishSQL
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2188
x780
x302
x247
x5

asked: Oct 27, 2014 at 01:39 PM

Seen: 486 times

Last Updated: Oct 28, 2014 at 10:16 AM

Copyright 2017 Redgate Software. Privacy Policy