Windows Thread, Constant corruption of system MSSQL 2005 files in Technical; We have a server with a fairly standard Microsoft SQL 2005 SP3 install, for some reason the system SQL files ...
21st September 2009, 05:27 PM #1
Constant corruption of system MSSQL 2005 files
We have a server with a fairly standard Microsoft SQL 2005 SP3 install, for some reason the system SQL files (i.e. master, msdb etc etc) seem to be corrupting at random under very little load.
I'm starting to think it could be disk hardware failure, is there a disk checking utility that works on Intel server motherboards and Samsung HD501LJ drives?
IDG Tech News
21st September 2009, 07:01 PM #2
I assume you've already used chkdsk? You could also try Samsung's ESTool, not sure how well it plays with RAID though.
21st September 2009, 08:30 PM #3
22nd September 2009, 05:04 AM #4
Does the server do anything else other than have a SQL 2005 install on it? i.e. running any other software on it, etc?
While its likely to be disc related, have you checked and/or swapped out the RAM modules? Even slightly duff RAM sticks could be causing it to corrupt etc IMO.
Thanks to tarquel from:
AngryTechnician (22nd September 2009)
22nd September 2009, 11:06 AM #5
Excellent advice, beat me right to it when I was thinking again about this earlier. Faulty RAM could absolutely cause this. The free version of memtest86 would be my recommendation for testing that.
22nd September 2009, 11:09 AM #6
I suspect it's either a combination of hard drive and memory or just one of the two. If you've run Scandisk and it comes back clean, then I suspect memory is the culprit. I presume you're using ECC memory? This is a must in any server.
1st October 2009, 05:57 PM #7
We rebuilt the server using a brand new hard drive and Server 2003 install, was getting the same 'Corrupt / Tampered' error on a fresh SQL install!
Originally Posted by googlemad
What Microsoft helpfully failed to point out is when using the SQLSERVR.EXE command line utility you need to do sqlservr.exe -s <instancename> for it to work if using anything other than a Default Named Instance!!! (Finally found it on Google but how does 'Your SQL Install is corrupt / tampered with' error help me!
By mpatsb in forum Network and Classroom Management
Last Post: 12th February 2009, 12:39 PM
By powdarrmonkey in forum Coding
Last Post: 30th September 2008, 01:38 PM
By trickstar in forum Windows
Last Post: 13th March 2008, 12:26 PM
By AlexB in forum MIS Systems
Last Post: 7th November 2007, 10:20 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)