October 13th, 2009

Previous Entry Next Entry
01:53 pm - How does this even happen?

(3 comments | Leave a comment)


[User Picture] From: clme
Date: October 15th, 2009 - 06:13 am
Is there a way to import a backup file rather than restoring it?
Can you edit it from another server?
Was it karma?
Was there some sort of black magic in the air on June 20th, 2008 at 8:03pm?
Do they know any Microsoft reps that may have been trying to get their business?

[User Picture] From: jimbojones
Date: October 15th, 2009 - 12:17 pm
SQL backups aren't like file backups; a SQL backup is the set of SQL commands required to create the tables backed up and populate them with the data in them. Which is actually how I discovered the problem to begin with - because running the SQL commands necessary to get the data in there would produce errors.

You can't edit SQL data directly, either, from that server or any other. You process it with, again, SQL commands that would error out if you attempted to violate the key constraints.

Always suspect the Microsoft reps... :shifty:

[User Picture] From: clme
Date: October 16th, 2009 - 08:50 am
Its just... well.. how the hell did it... I mean...

Hell, you have to try to mess up tables like that. I need to take lessons from whoever pulled that off because I am obviously not as good as I thought at breaking shit. :-)

> Go to Top