Subscribe to my newsletter EDM News
Are your vendors backing up your data?
27 July 2016, by , in Data Management, 2 comments

One of my favorite aphorisms in data management is “There are those who backup, and those who will.”

Once you’ve had one catastrophe with a missing or corrupt backup, you’ll never forget about backing up again.

Or will you?

More and more, data systems are being hosted by third-party vendors. And part of that service is periodic backups of your data. But have you ever checked with your vendor(s) to ensure the data is actually being backed up? Ask your vendor(s) to prove they are backing up your data.

So maybe we need a new mantra: “There are those who check on their vendor backups, and those who will.”

About author:

2 Comments on "Are your vendors backing up your data?"

Rene Shonerd - 2 August 2016 Reply

When brand new on the job, I asked about the backup schedule on our critical applications. I was told that our managed service vendor was handling it. I investigated further and learned that the managed service vendor was taking server level snapshots per the contract, but no SQL backups were scheduled for any of the 3 applications on the server. I spent the rest of that day setting up backup routines for each SQL instance to run nightly backups and mid-day transaction logs. I agree with Wes and would recommend you check the backups with your hosting vendor AND your application support vendor because you need both. The SQL backups are needed in the case that the software application fails and the server level snapshots would be best in a distaster recovery scenario. And after you make sure backups are running on a regular schedule, I would ask your application support vendor about SQL maintenance routines to keep the database running at peak performance. My second week on the job, I learned that no standard SQL maintenance had been performed in over 5 years. Yikes. Ultimately, it is the association's responsibility, not the vendor's, to ensure backups are occurring regularily. A vendor partner should welcome these questions and should be happy to show you the files, or better yet, offer to run a full restore to test the backups will work as intended, should you ever need it.

    Wes Trochlil - 2 August 2016 Reply

    Excellent advice, Rene! Thanks for sharing.

Leave a Reply

Archives

Sign-up for EDM News

 

 

Testimonials

“Wes was able to come in and offer tangible, relevant advice that made us more productive immediately. I value his understanding of databases but more so, his understanding of how nonprofits work. There was no lost time educating him about how membership organizations are “different.” Wes recommended changes in processes as well as tips and tricks that were easy to implement made an immediate positive impact.”

Mary Pat Paris, Executive Director
International Registration Plan

“We came to Wes because we were very frustrated with our existing AMS and we wanted to improve our capabilities as soon as practicable. Wes very quickly helped us through a process of identifying our needs, identifying potential vendors, and selecting a new system that we’ll be able to move into very quickly. I especially appreciated Wes’s candor about our processes as well as the systems we were looking at. He was a great resource to have in a period of high anxiety for our organization. I would highly recommend Wes for any similar project.”

Jack Chiasson, CMP Executive Director
National Association of Life Brokerage Agencies

“Wes was able to come in and offer tangible, relevant advice that made us more productive immediately. I value his understanding of databases but more so, his understanding of how nonprofits work. There was no lost time educating him about how membership organizations are “different.” Wes recommended changes in processes as well as tips and tricks that were easy to implement made an immediate positive impact.”

Mary Pat Paris, Executive Director
International Registration Plan

Mary Pat Paris
International Registration Plan

“This is the second database implementation we’ve done since I have been at Western Arts Alliance (WAA). The first I did on my own. This time we engaged Wes Trochlil as our database planning consultant. Let me tell you, this process is a whole lot easier having Wes on your team! For a small association like WAA, it’s tempting for board and EDs to question the justification and expense of a database planning consultant. But it’s the small associations that need Effective Database Management the most. Wes strengthened our planning process, clarified our needs requirements, helped us steer around solutions that couldn’t meet our objectives, and saved us money in the long haul.”

Tim Wilson, Executive Director
Western Arts Alliance

Tim Wilson
Western Arts Alliance
%d bloggers like this: