The data-integrity tag has no wiki summary.
0
votes
3answers
114 views
Which SSD to choose, when unexpected powerlosses are frequent?
I am working on a embedded system where there can be unexpected power losses. So far it has been using a Corsair F80 SSD with Windows Embedded Standard 7 (NTFS), and after a unexpected power loss ...
2
votes
1answer
613 views
How to get checksum data integrity on ext4?
On file systems like btrfs you can preform a scrub, which will go though all the data to see if the data still matches the file system checksum.
I would like to check the data on ext4 if it is ...
2
votes
2answers
101 views
Single file changed: intrusion or corruption?
rkhunter reported a single file change on a virtual server (netstat binary). It didn't report any other warning. The change was not the result of a package upgrade (I reinstalled it and the checksum ...
1
vote
1answer
392 views
DB2 Integrity Checks and Exception Tables
I am working on planning a migration of a DB2 8.1 database from a horrible IBM encoding to UTF-8 to support further languages etc. I am encountering an issue that I am stuck on.
A few notes on this ...
3
votes
2answers
201 views
Detecting data corruption so we're not backing up corrupt files
I've been thinking about data integrity, I currently backup about 2tb of data and always have one backup of data from a year ago.
My concern is if a file became corrupt on our production file server ...
0
votes
1answer
255 views
Best practices for mass file transfer with verification?
I'm looking for a bit of advice on transferring a several files from Windows-based workstations to a Linux Server running Ubuntu Server LTS 10.04. At the moment I've been mounting the shares on the ...
1
vote
3answers
366 views
Best practices for backing up Windows workstations to Linux server?
I was wondering what strategies others in the community use when backing up their Windows-based workstations to Linux servers. At the moment I'm doing a bit of a test with Ubuntu Server LTS 10.04 and ...
2
votes
2answers
352 views
What happens to InnoDB and MyISAM tables if the power fails during a transaction?
We have two MySQL tables, one is InnoDB and the other is MyISAM. If I execute a chunk of inserts in a single transaction on both tables and the power fails in the middle, what will be the status?
...
1
vote
0answers
47 views
Archival storage tool: fast, queryable, has api, reliable
I have large quantities of structured data coming in over the network from disparate sources, and that data is archived in the filesystem, parsed/analyzed, and eventually makes it's way into a ...
84
votes
4answers
21k views
LVM dangers and caveats
I have recently started using LVM on some servers for hard drives larger than 1 TB. They're useful, expandable and quite easy to install. However, I could not find any data about the dangers and ...
5
votes
3answers
3k views
Making SATA disk write cache safe
Supposedly (see, e.g., a question about it here), with NCQ enabled drives, the drive write cache is supposed to be safe, as in it doesn't like to the OS about data being committed to the platters when ...
5
votes
2answers
629 views
PCI Compliance: File Integrity Checkers
We're looking for a file integrity checker for our windows server environment. Anyone have any good suggestions?
1
vote
2answers
525 views
Upload over HTTPS is reliable?
Sometimes we are facing a problem with corrupted files after upload through HTTP protocol.
Today I’ve read an article that says that TCP protocol is not 100% reliable due to weak CRC algorithm and ...
2
votes
5answers
446 views
Is there any value in checking MD5 of files after they have been unzipped?
A project I am working on currently requires that the user runs an MD5 hash checking tool on the entire project, after it has been unzipped. They do not currently request that the ZIP itself is ...
0
votes
2answers
253 views
SQL: Find Last Integrity Check Date
Is there a way to check when was the last integrity check run for each database?
I know when the service startup it checks for these values, so they exist, and they are probably writen on the ...
4
votes
2answers
2k views
It is XFS reliable? In case of a power gone off is xfs riskier that ext3 in data corruption/safey?
I have been having some electrical issues,mostly power going out suddenly for a few months,and although ups solve the thing mostly.
But still i am worried about filesystem corruption,and data lost.
...
5
votes
2answers
4k views
How to check PostgreSQL database integrity?
Is there a way to check PostgreSQL database(s) integrity and consistency? I know about SQL Server DBCC CHECKDB and wonder if there is something similar to PostgreSQL.
0
votes
3answers
41 views
How two or more guest OS's hosted in a virtual environment handles editing of single resource?
I know this sounds very general question.
Consider 2 OS's running using virtualization say operating system level virtualization. How concurrency is handled if both hosted OS using same resource and ...
0
votes
1answer
233 views
Why does DBCC CHECKTABLE report errors on non-existent pages?
When I run DBCC CHECKDB, I get a slew of error messages like this:
Table error: object ID 2020918271, index ID 1, partition ID 72057594196590592, alloc unit ID 72057594190233600 (type In-row ...
0
votes
3answers
1k views
How to verify integrity of a remote file transfer
Is there any way I can verify the integrity of a remotely transferred file? I am currently transferring a large amount of files and folders from an ftp server to another remote server using wget, but ...
0
votes
2answers
64 views
Is there a service I can run which will automatically test CPU/RAM/hardware in the background?
Is there any service which runs in the background, and does the job of prime95 (i.e. it tests server CPU/RAM for integrity now and again)?
Regards,
Shane.
p.s. The reason I ask: we recently had some ...
0
votes
1answer
408 views
Best way to add a new non-nullable column?
I'm a web developer, with admin rights on our SQLServer, and I need to add a non-nullable integer column (foreign key) to an existing table. I'm looking for the best way to create this column and ...
4
votes
4answers
396 views
Disaster Recovery/Sabotage Protection for a small business
I've been contacted by two partners in a small professional firm. They are concerned about their other partner and want to take some steps to be absolutely sure that the company's data and systems ...
6
votes
4answers
1k views
USB storage media - data integrity issues on linux
I've always been somewhat paranoid about verifying data backed up to removable media, so after copying stuff to a USB flash drive or portable HDD, I invariably unmount the drive, remount it and diff ...
11
votes
5answers
7k views
SATA Disks that handle write caching properly?
It's pretty common to see advice to disable the write cache on individual disks used for databases because otherwise some disks will acknowledge writes that haven't yet made it to the disk surface.
...
