Login or Sign Up to become a member!

EXPERTS, INFORMATION, IDEAS & KNOWLEDGE

Social bookmarker Add this

Your profile

Search

July 2009
Mon Tue Wed Thu Fri Sat Sun
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

XML Feeds

Authors

« Altering the Schema of a stored procedure in SQL-server 2005SQL Friday, The Best SQL Server Links Of The Past Week Episode 5 »
The Data Management Journal

Site is no more after they discover they did not have SQL Server backups

by SQLDenis


Permalink 04 Jan 2009 06:31 , Categories: Data Modelling & Design Tags: availability, backups, best practice, recovery

Oops, that sucks Journalspace is no more.
Here is what they have said about this on their blog

It was the guy handling the IT (and, yes, the same guy who I caught stealing from the company, and who did a slash-and-burn on some servers on his way out) who made the choice to rely on RAID as the only backup mechanism for the SQL server. He had set up automated backups for the HTTP server which contains the PHP code, but, inscrutibly, had no backup system in place for the SQL data. The ironic thing here is that one of his hobbies was telling everybody how smart he was.

This doesn't excuse what happened, though: I should have taken a better look at what he'd left behind, and fixed all of the things that needed fixing.

That is just bizarre, to set up backups is one of the easiest things to do in SQL Server and should also be one of the first things you do. You also have to make sure that you test these backups because if you can't recover from them then you do NOT have backups
Another thing that you should be aware of is that the backup should never ever be in the same location as your server. It should be stored in another location preferably at least 50 miles from the original location. We had our servers in WTC building one and the backups in WTC building 2, you already know how that ended........

5 comments »Send a trackback » 1023 views

Trackback address for this post

Trackback URL (right click and copy shortcut/link location)

5 comments

Comment from: cbetancourt [Member] Email
Word of the day: *inscrutibly* - a crazy of way of saying incredibly.
01/04/09 @ 07:06
Comment from: SQLDenis [Member] Email
Maybe he meant inscrutably?
01/04/09 @ 07:13
Comment from: Video Security Services of Nashville [Visitor] · http://www.nmnetworkservices.com/video%20security.asp?id=nashville
*****
Those who talk the talk tend not able to walk the walk!
01/04/09 @ 21:13
Comment from: OracleDave [Visitor]
***--
So was the company folding anyway?? Why would they sell the URL unless they were going under anyway?? What's the full story here?
01/06/09 @ 10:22
Comment from: SQLDenis [Member] Email
OracleDave , it looks like they are selling the URL since they don't need it anymore after they lost all the data
01/06/09 @ 10:28

Leave a comment


Your email address will not be revealed on this site.

Your URL will be displayed.
PoorExcellent
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)