Heres what happened to me. The power supply on my PC stopped working,
so I replaced it. In the process of replacing it, I removed my network
card from the PCI slot and then later put it back in - perhaps in
another slot number, i dont know.
I am running W2K Server + SQL2K Server.
So the next thing that happens is that W2K does not recognize the
network card and when I try to re-install it, says the static IP
address I use is already assigned to a card which is "temporarily
removed or unavailable" or words to that effect. I am not able to
un-install the old card through any manipulation of control panel,
etc. But I am not a virtuoso at this either, just tried the obvious
Meanwhile, SQL2K is absolutely refusing to start. nada. The service
wont start, period.
So at this point I am out of options, unless I go into regedit. :(
So what I do next is unistall SQL2K and W2K. I reinstall W2K (in hopes
it will forget about me moving the card, sortof like shock therapy
treatment.) And then I re-install SQL2K.
At this point, everything works even before I apply the service packs.
(CAPS ONLY FOR READABILITY!):
BUT THE QUESTION IS:
I HAVE LOST ALL MY DATA IN THIS PROCESS. (OK - BECAUSE DATA WAS NOT
CRITICAL.) BUT GIVEN THAT PC'S ARE UNRELIABLE AND WILL OCCASIONALLY
HAVE HARDWARE CRASHES, AND GIVEN THAT W2K-SQL2K SEEMS SENSITIVE TO
EXACT HARDWARE CONFIG, HOW SAFE IS MY DATA IN THE FUTURE WITH THIS
SETUP? IN OTHER WORDS, IS IT POSSIBLE TO BACK UP DATA SOMEHOW? THIS
HAS ME WORRIED.