| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-11-28 : 03:37:08
|
Now that the Data Corruption forum has been going a while can someone please explain to me why every time I read a message in there I want to run off and test my backups.  steve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-28 : 03:53:52
|
| If it helps ...... I've stopped reading the posts in there!Kristen |
 |
|
|
jhermiz
3564 Posts |
Posted - 2005-11-28 : 10:12:59
|
quote:
Originally posted by Kristen
If it helps ...... I've stopped reading the posts in there!Kristen
It's really scary in there, I've pepped in a few times only to find myself more confused. Paul R. is holding it off pretty well though, knowledgeable guy, me thinks he is a robot
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-28 : 14:06:58
|
| "me thinks he is a robot"ROTFL! |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-11-28 : 14:31:02
|
| Anyone know the top 5 causes of data corruption? (This isn't a joke, I am only curious) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-28 : 14:38:41
|
| The number one cause is disk problems. The rest are going to be different hardware probems.Tara Kizeraka tduggan |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-11-28 : 14:39:28
|
quote:
Originally posted by SamC
Anyone know the top 5 causes of data corruption? (This isn't a joke, I am only curious)
Post it in the data corruption forum, Paul R. prolly has a good answer.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
jhermiz
3564 Posts |
Posted - 2005-11-28 : 15:08:04
|
quote:
Originally posted by Michael Valentine Jones
It's amazing the number of people posting there that have no backup at all or one that's a month old.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57995http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57301http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57081Makes me want to cringe. I know backups aren't fun to setup and manage, but how can you put yourself in that position?CODO ERGO SUM
Funny you mention that one of the engineers that has been working on a "ECN" database in our company got a call from me today. I noticed he had no backups listed for his database. When I called him and asked him if he wanted me to set him up with a backup procedure / process he stated nah we don't need one, we should have no problems. That's what I used to think :).
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-11-28 : 15:18:46
|
Call him up in a couple of days and tell him you just accidentally dropped all the objects in his database, say you are sorry for the inconvenience, and ask if he can please recreate all his objects and data from scripts.When he's done hyper-ventilating and crying, tell him you were just kidding, and ask if he still feels he doesn't need a backup.  quote:
Originally posted by jhermiz
quote:
Originally posted by Michael Valentine Jones
It's amazing the number of people posting there that have no backup at all or one that's a month old.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57995http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57301http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57081Makes me want to cringe. I know backups aren't fun to setup and manage, but how can you put yourself in that position?CODO ERGO SUM
Funny you mention that one of the engineers that has been working on a "ECN" database in our company got a call from me today. I noticed he had no backups listed for his database. When I called him and asked him if he wanted me to set him up with a backup procedure / process he stated nah we don't need one, we should have no problems. That's what I used to think :).
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url]
CODO ERGO SUM |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-11-28 : 15:20:45
|
Wicked we are  ...He'll get the idea one day, then when it happens BOOOOOOOOM why didn't I think of that :).
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-11-28 : 17:50:40
|
| people don't learn from their mistakes, they just cover them up better the second time--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2005-11-29 : 00:56:29
|
| I think it has 2 causes.1) SQL Server is easy to use out of the box.2) Too young! A lot of people haven't seen let alone used a 5 1/4 floppy. In those days if you didn't have 3 or 4 copies of everything (OS, applications and data lived on them remember) you where screwed.DavidMIntelligent Design is NOT science.A front-end is something that tries to violate a back-end. |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-11-29 : 01:12:11
|
| Ah, 5 1/4 floppy disks were luxury in my day. Back when I were a lad you had to save all your data by writing it down in cuniform on a clay tablet...--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2005-11-29 : 01:15:50
|
| I made a typo... I just changed it to 5 1/4...Cuniform... bloody technocrat.. We used to grunt to each other in morse code!And the only way to make a backup was to get lucky..DavidMIntelligent Design is NOT science.A front-end is something that tries to violate a back-end. |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-11-29 : 01:18:47
|
| Grunt! Luxury that, we weren't allowed to make any noise when I were a lad....--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2005-11-29 : 01:21:31
|
| >>Grunt! Luxury that, we weren't allowed to make any noise when I were a lad...LOL Rob!What about when you got lucky?DavidMIntelligent Design is NOT science.A front-end is something that tries to violate a back-end. |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
|
|
jhermiz
3564 Posts |
Posted - 2005-11-29 : 08:54:17
|
quote:
Originally posted by Sitka
OT RE brymol's sig.http://www.venganza.org/"it's definitely useless and maybe harmful".
What a goofball, profiting from t-shirts on a spaghetti god?Sounds childish
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-12-01 : 17:09:44
|
quote:
What about when you got lucky?DavidM
....luxury....--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
Next Page
|
Is it me