Questions tagged [checksum]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
68 views

How to check if backups are reliable?

I generally have to restore databases to different servers after important data imports or other important and delicate database operations. I need to be sure that my backups up to that point in time ...
2
votes
2answers
26 views

Will I be notified that BACKUP encountered a CHECKSUM error if I use CONTINUE_AFTER_ERROR?

I am in the process of adding the WITH CHECKSUM flag on our daily SQL backups, as part of an effort to better ensure data integrity. I definitely want to know if a checksum error is ever encountered, ...
1
vote
1answer
439 views

Is there any function like checksum in Oracle

I need to calculate the checksum of some columns. The built-in function checksum is used to calculate the checksum in Microsoft SQL Server. Is there any built-in function checksum in Oracle?
0
votes
1answer
40 views

SQL 2016 Changing Page Verify Impact

Recently inherited a new SQL server and after some Blitz (Thanks Brent and team) checks have noticed that some of the DB's are set to Torn_Page or None for the page verify option. I want to change ...
0
votes
1answer
276 views

Validation of data with checksum vs Binary_checksum

Based on this post, I was able to solve the performance issue by adding indexes and thought I completed my project until I ran into an issue with the checksum... I then did research (should have done ...
1
vote
2answers
173 views

varchar(255) field or hash field?

To consider a table with millions records and the table schema: CREATE TABLE `foos` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `foo` varchar(255) COLLATE utf8_unicode_ci NOT NULL, ...
2
votes
1answer
174 views

How to verify (CHECKSUM or MD5) dataset you received over a network?

I will remotely query mysql database and I want to check that the received dataset matches the table in the host computer. How do you do that? I am fairly new to sql database. I know of Checksum and ...
0
votes
1answer
443 views

what is an InnoDB Page checksum?

What is an InnoDB Page checksum exactly? Does a Page checksum only detect issues with underlying storage when writing or reading to a page/block?
2
votes
1answer
83 views

How to guarantee rows order

I'm trying to implement a methodology to check the integrity of a restored database. It goes as following: Create a snapshot of the database. Gather various metadata: On disk used space. Name of ...
0
votes
1answer
256 views

Check integrity between servers

I have three Database servers, running PostgreSQL 9.2: master01 (Own data center USA) slave01 (Own data center USA) slave02 (AWS Australia) Both slaves use streaming replication + ...
1
vote
0answers
452 views

Mysql checksum for data only

I have some groups of two tables, each group table having the same structure. (dev & prod server) Their data will never change from user action, only from admin when a change occurs. I want to ...
5
votes
1answer
327 views

How to Resolve Corruption Detected by BACKUP WITH CHECKSUM, But NOT DBCC CHECKDB?

Recently, I was asked to refresh a couple of databases on a test server from production. Always wanting to follow best practices, I performed the backup using the WITH CHECKSUM option, and eventually ...
8
votes
1answer
1k views

Null Values in a CASE statement

I am playing around with some stuff in SSMS to learn a little more as I study for my 70-461 exam and I came across a little hangup. I am trying to create a table to play around with so I don't have to ...
2
votes
2answers
2k views

Mysql checksum for master-slave replication returning different values, despite being identical

I've set up a master slave replication in mysql and to make sure that I know if the data starts getting out of sync I created a script that: Locks both databases on both servers. Prints the checksums ...
11
votes
1answer
589 views

How do data checksums interact with streaming replication?

Data checksums are a new feature introduced in 9.3, and: there is a new GUC parameter "ignore_checksum_failure" which will force PostgreSQL to continue processing a transaction even if corruption ...