One of my articles just got posted up at SearchSQLServer. I cover some of the pros and cons of backing up data warehouses with SAN snapshots.
I wrote that just after we got done with a NetApp deployment at Southern Wine. The funny part is that we deployed the QA environment pretty quickly, but months after I’ve left, they still haven’t moved the production warehouse over to the NetApp. I should have borrowed that set of drives until they were ready to go live, heh.
Update as of 6/3 – I originally wrote that article for SearchSQLServer.com. I didn’t see the article appear there for a while, and when it popped up on SSWUG, I assumed SearchSQLServer had transferred it over to SSWUG. Turns out that’s not the case. We’re working through the details of that now.
This isn’t the first time one of my articles has been “pirated” – used to happen to me when I wrote for HAL-PC – but this is the first time it’s happened with an article I actually got paid to write. Next thing you know, I’m going to need an agent. Or maybe not.
4 Comments. Leave new
Ok so at the risk of being laughed at I don’t have a SSWUG paid membership and I want to read this article. Is this a must have and I’ve been missing out? If so what’s the level I can survive at, elite or enhanced?
JC
Let the laughing commence. I don’t have a paid membership either. 😉
Hi Brent,
I was wondering if you have any thoughts on using san snapshots (only) for database backups across OLTP and DW environments?
I’m personally very anxious about this idea, but would love to hear what your thoughts are on this issue.
Thanks in advance for any response as I can only imagine how busy you are!
Really appreciate all your help and look forward to seeing you at a SQL BITS conference soon!
Thanks,
Iwan
Iwan – howdy! It’s beyond what I can cover fast in a blog post comment, but we cover it in our online classes here:
https://www.brentozar.com/training/hardware-storage-virtualization/16-storage-advanced-features-snapshots-replication-migrations-22m/