Versions of Disaster

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » Versions of Disaster

12 posts, Page 2 of 2

««1 2

Versions of Disaster

Rate Topic

Display Mode

Topic Options

Author

Message

FFalcon1961

Posted Tuesday, January 13, 2009 11:52 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, September 08, 2011 6:11 AM
Points: 31, Visits: 336

Isn't this what change management requests are for. To keep track of what and when things are being done. Yes the data might be on the system that crashed that is why a hard copy is kept is a safe location. Keeping up with documentation is the worst part of the job. However, it is also one of the major parts of the job.

Post #635716

GSquared

Posted Tuesday, January 13, 2009 12:01 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

I read a story about a shop that kept point-in-time restore data for all applications on all servers, throughout their history. They could restore any retired server, into a virtual environment, exactly as it had been on the particular day they needed.

One day, this became crucial for legal reasons, and they restored an old server into a virtual environment, with the databases and so on exactly as they had been on the critical day. And nobody could remember what the admin passwords had been, so the data might as well have not existed.

True or not, it was an amusing read. If true, I'm sure it was not so amusing to the people involved.

There are easy ways around that issue in SQL Server, of course.

As for keeping server version data, that's easy enough to do, but it isn't quite automatic. Good point, since it could very well matter when doing a restore.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #635723

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions