I had the day already planned. I should be going to the shop and stay the whole day there until 5PM for our regular Saturday Praise and Worship Practice.
8:30AM: I received a text message that there is an error with the Business License Program so I have to rush to the Office to fix anything that might have cause the error, to my surprise 4 of the main table of the database was corrupted and no longer have any record! ah! again.. AHHH! What???? HOW? to cut the story short. its unfixable. Solution? restore the back-up.. What? The Friday backup has the erroneous data? Does that mean we have to restore the Thursday backup? Yes, Oh my... thats almost 200 transaction lost! Again to cut the story Short, Jess has to work at home via dial-up to restore Thursday backup.
Lesson? Hmm.. Better have a 12:30PM, 5:30PM and a 9:00PM backup daily. Thats the beauty of technology or should I say the other way around?
Hey, any suggestions? I'm open to as many as you can provide. Thanks!
Sinabi mo!
ReplyDeleteJessie, help! We still have problem with the SQL, gumagapang!
It's finally over!
ReplyDeleteWe've been using MyOLEDB (the connection I use for VB to communicate with MySQL) for three years now and come 2006, it finally broke down. Its like a time bomb... triggered last friday.. causing so much damage. But finally its over, we have used MyODBC instead and the system is working like the way I want it.