January 28, 2014 at 5:12 am
Ok here is the story and need to know how to fix the issue.
in Oct 2012 we bought medical software for our office it runs with SQL server 2008 we have most of the ophthalmic machines networked through the server. About 8 months ago we started getting Data corruption pop ups with the database. I would call the support people for medical software they would remote in and review the data and there would be no corruption. This happened about 3 times in 2 months, so that was when i had my IT person come in and I sat there with him we did a chkdsk we looked through everything we could possibly look through and found nothing wrong with the hardware of the machine, no Hdd issues, etc. So then the database worked great for another 2 - 3 months then it happened again with the data corruption pop up, software company support didn't find any data corruption.
This time had IT people come in we checked everything and still nothing so thought we re-intalled all software including SQL and installed new memory sticks, the dbase worked fine until another 2-3 months. This time I gave up a Saturday went into work and reviewed the event viewer I would see an error i would look up on the internet as to what this error would mean. I found an error about the DHCP, so i called my IT person and this is when I found out they had set up the DHCP onto our Cisco Wireless router, so now i said should that be on the server and so IT person moved DHCP from router to server. Remember we have found nothing wrong with the server hardware and most of our ophthalmic machines are networked to the server and all the computers and nothing is happening with them
Ok so that we could still work with our database software company moved the database into my computer and used SQL express, weird thing this database has been on my computer since about end of october 2013, we have had no issues even when power goes down. So now I want to know if anyone out there can tell me if the DHCP was on the router and our internet service is cable if it is sporatic going up and down would this cause the false data corruption error? Also, since the database has been on my computer the DHCP has been on the server. So I would like to get the database back on the server but before i did i wanted to know if anyone else had any clue as to what maybe happening with the sql server.
Thank You,
Jamie Coley
Ponce, Puerto Rico
January 28, 2014 at 6:00 am
When you say 'data corruption', what exactly do you mean? What errors, what symptoms, etc
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 28, 2014 at 6:46 am
When we go to log into our medical software (Nextech) we get an pop up box that is pink which has May have Data Corruption and to call the
Nextech Support. Just so you know we tried to get someone from there to come to Puerto Rico to be here in person to review the system.
At first we thought because the power went out as the software was set up to do a backup of data at the time. Then we realized which I just now remembered that the backup for Nextech and the Microsoft Essential Anti-Virus software was clashing.
Nextech had set up back up on timer to start at 12 midnight each night would do backups then on Friday night would do a document back up and then the Anti-virus was set up on timer to do a scan at 2 am on saturday mornings so we seemed to think the softwares was clashing. so we have changed the times on each one and that seemed to help.
When the pop up about data corruption is for nextech we call support they run a query that will check for any corruption.
Jamie Coley
January 28, 2014 at 6:59 am
I can't tell from that what's going on. That 'May have Data Corruption' is an application error, could be anything triggering that. Without knowing the technical details, no way to tell what's really happening or what might be the cause.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply