{"id":4679,"date":"2026-06-14T19:31:06","date_gmt":"2026-06-14T19:31:06","guid":{"rendered":"https:\/\/cloudsave.app\/?p=4679"},"modified":"2026-06-15T15:18:07","modified_gmt":"2026-06-15T15:18:07","slug":"an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste","status":"publish","type":"post","link":"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/","title":{"rendered":"An D\u00fanmharf\u00f3ir Ci\u00fain: Conas C\u00faltaca\u00ed Bunachar Sonra\u00ed \u00c9illithe a Bhrath Sula dTarla\u00edonn Tubaiste"},"content":{"rendered":"

I saol ard-riosca na riarach\u00e1in bunachar sonra\u00ed agus na hinnealt\u00f3ireachta iontaofachta su\u00edomhanna, t\u00e1 aicsi\u00f3m aitheanta ann: C\u00faltaca Schr\u00f6dinger<\/em>. N\u00ed fios riocht aon ch\u00faltaca go dt\u00ed go nd\u00e9anann t\u00fa iarracht \u00e9 a athch\u00f3iri\u00fa. Go dt\u00ed an n\u00f3im\u00e9ad sin, t\u00e1 s\u00e9 i staid chandamach ina bhfuil s\u00e9 ag an am c\u00e9anna go hioml\u00e1n in\u00fas\u00e1idte agus go hioml\u00e1n truaillithe.<\/p>\n

I gc\u00e1s innealt\u00f3ir\u00ed DevOps agus riarth\u00f3ir\u00ed bunachar sonra\u00ed (DBAanna), is \u00e9 an tromlu\u00ed deiridh \u00e9 a fh\u00e1il amach go bhfuil c\u00faltaca r\u00edth\u00e1bhachtach bunachar sonra\u00ed truaillithe le linn teagmhais ghn\u00edomhaigh. Athra\u00edonn s\u00e9 oibr\u00edocht ghn\u00e1th-athch\u00f3irithe ina thubaiste caillteanais sonra\u00ed. Is minic nach dtugtar faoi deara an “marf\u00f3ir ci\u00fain” seo ar shl\u00e1ine sonra\u00ed toisc go dtuairisceoidh poist ch\u00faltaca go minic Exit Code 0<\/code> rath\u00fail fi\u00fa nuair a bh\u00edonn an t-ualach bun\u00fasach curtha i mbaol.<\/p>\n

Sa treoir chuimsitheach seo, d\u00e9anfaimid anail\u00eds ar anatama\u00edocht na truaillithe c\u00faltaca, d\u00e9anfaimid ini\u00fachadh ar theicn\u00edc\u00ed bail\u00edochtaithe a bhaineann go sonrach le bunachair sonra\u00ed, agus l\u00e9ireoidh muid conas p\u00edbl\u00ednte athch\u00f3irithe uathoibrithe, do-bhriste a th\u00f3g\u00e1il do thimpeallachta\u00ed t\u00e1irgthe.<\/p>\n

Anatama\u00edocht na Truaillithe C\u00faltaca<\/h2>\n

Chun truailli\u00fa a bhrath, n\u00ed m\u00f3r duit a thuiscint ar dt\u00fas conas a tharla\u00edonn s\u00e9. Go ginear\u00e1lta, titeann truailli\u00fa c\u00faltaca isteach i dh\u00e1 chatag\u00f3ir: fisici\u00fail (leibh\u00e9al an bhonneagair) agus loighci\u00fail (leibh\u00e9al an fheidhmchl\u00e1ir).<\/p>\n

Truailli\u00fa Fisici\u00fail<\/h3>\n

Tarla\u00edonn truailli\u00fa fisici\u00fail nuair a athra\u00edtear na giot\u00e1in iarbh\u00edr ar an me\u00e1n st\u00f3r\u00e1la. Is f\u00e9idir \u00e9 seo a tharl\u00fa le linn an phr\u00f3isis l\u00e9itheoireachta \u00f3n diosca foinse, le linn iompair l\u00edonra, n\u00f3 agus \u00e9 ar fos ar an st\u00f3r\u00e1il sprice.
\n* Lobhadh Giot\u00e1n (Bit Rot):<\/strong> Is f\u00e9idir le d\u00edghr\u00e1d\u00fa de r\u00e9ir a ch\u00e9ile ar na me\u00e1in st\u00f3r\u00e1la giot\u00e1in a smeach go ci\u00fain.
\n* Earr\u00e1id\u00ed Iompair:<\/strong> C\u00e9 go bhfuil seice\u00e1lacha suime (checksums) ag TCP, t\u00e1 siad go dona (16-giot\u00e1n). Is f\u00e9idir le timpeallachta\u00ed ard-thr\u00e9chuir truailli\u00fa sonra\u00ed ci\u00fain a fh\u00e1il thar an sreang nach n-\u00e9ir\u00edonn le TCP a ghabh\u00e1il.
\n* Fabhtanna Rialaitheora St\u00f3r\u00e1la:<\/strong> Is f\u00e9idir le fabhtanna crua-earra\u00ed i rialaitheoir\u00ed RAID n\u00f3 fabraic\u00ed SAN sonra\u00ed bruscair a scr\u00edobh agus rath a thuairisci\u00fa don OS.<\/p>\n

Truailli\u00fa Loighci\u00fail<\/h3>\n

Is f\u00e9idir a r\u00e1 go bhfuil truailli\u00fa loighci\u00fail n\u00edos cont\u00fairt\u00ed toisc go bhfuil an comhad c\u00faltaca f\u00e9in sl\u00e1n go hioml\u00e1n, ach t\u00e1 na sonra\u00ed taobh istigh de briste.
\n* Bruscar Isteach, Bruscar Amach (GIGO):<\/strong> M\u00e1 t\u00e1 inn\u00e9acs truaillithe n\u00f3 leathanach str\u00f3icthe ag do bhunachar sonra\u00ed beo, d’fh\u00e9adfadh do uirlis ch\u00faltaca an leathanach truaillithe sin a ch\u00f3ipe\u00e1il go d\u00edlis. \u00c9ir\u00edonn leis an bpost c\u00faltaca, ach teipfidh ar an athch\u00f3iri\u00fa n\u00f3 cruth\u00f3idh s\u00e9 bunachar sonra\u00ed briste.
\n* Idirbhearta Neamhioml\u00e1na:<\/strong> Is c\u00fais le leathanaigh str\u00f3icthe agus st\u00e1it nach f\u00e9idir a athch\u00f3iri\u00fa iad snapshots ar leibh\u00e9al an ch\u00f3rais comhad a th\u00f3gtar gan I\/O an bhunachair sonra\u00ed a reo i gceart (m.sh., gan FLUSH TABLES WITH READ LOCK<\/code> a \u00fas\u00e1id i MySQL).<\/p>\n

Brath R\u00e9amhghn\u00edomhach: Seice\u00e1lacha Suime agus Hash\u00e1il Chripteagrafach<\/h2>\n

Is \u00e9 bail\u00edocht\u00fa cripteagrafach an ch\u00e9ad l\u00edne cosanta i gcoinne truaillithe fisici\u00fala. N\u00ed leor brath ar mh\u00e9ideanna comhad n\u00f3 d\u00e1ta\u00ed modhnaithe.<\/p>\n

Seice\u00e1lacha Suime ar Leibh\u00e9al an Bhunachair Sonra\u00ed a Chumas\u00fa<\/h3>\n

Taca\u00edonn c\u00f3rais bhainist\u00edochta bunachar sonra\u00ed coibhneasta (RDBMS) nua-aimseartha le seice\u00e1lacha suime ar leibh\u00e9al an leathanaigh. Nuair a bh\u00edonn siad cumasaithe, r\u00edomhann an bunachar sonra\u00ed seice\u00e1il suime do gach leathanach sula scr\u00edobhtar chuig an diosca \u00e9. Nuair a l\u00e9itear an leathanach (tr\u00ed cheist n\u00f3 pr\u00f3iseas c\u00faltaca), d\u00e9antar an seice\u00e1il suime a fh\u00edor\u00fa.<\/p>\n

Maidir le PostgreSQL<\/strong>, is f\u00e9idir leat seice\u00e1lacha suime sonra\u00ed a chumas\u00fa le linn t\u00fas\u00fa an chnuasaigh:<\/p>\n

# Cnuasach nua PostgreSQL a th\u00fas\u00fa le seice\u00e1lacha suime cumasaithe\ninitdb --data-checksums -D \/var\/lib\/postgresql\/data\n<\/code><\/pre>\n
N\u00f3ta: M\u00e1 t\u00e1 cnuasach PostgreSQL agat cheana f\u00e9in, is f\u00e9idir leat an f\u00f3ntais pg_checksums<\/code> a \u00fas\u00e1id chun iad a chumas\u00fa as l\u00edne.<\/em><\/p>\n
Maidir le Microsoft SQL Server<\/strong>, cinntigh go bhfuil PAGE_VERIFY<\/code> socraithe go CHECKSUM<\/code> (an r\u00e9amhshocr\u00fa i leaganacha nua-aimseartha, ach is fi\u00fa \u00e9 a fh\u00edor\u00fa ar sheanch\u00f3rais):<\/p>\n
ALTER DATABASE [ProductionDB] SET PAGE_VERIFY CHECKSUM;\nGO\n<\/code><\/pre>\n
C\u00faltaca\u00ed ar Fos a Fh\u00edor\u00fa<\/h3>\n
Nuair a shroicheann an c\u00faltaca do sprioc st\u00f3r\u00e1la, n\u00ed m\u00f3r a shl\u00e1ine a fh\u00edor\u00fa go cripteagrafach. R\u00edomhann ard\u00e1in ch\u00faltaca fiontair cos\u00fail le CloudSave hashes SHA-256 de bhloic ch\u00faltaca go huathoibr\u00edoch le linn iompair agus ar fos. M\u00e1 t\u00e1 scripteanna saincheaptha \u00e1 mbainisti\u00fa agat, n\u00ed m\u00f3r duit \u00e9 seo a chur i bhfeidhm de l\u00e1imh:<\/p>\n
# Hash SHA-256 a ghini\u00faint tar \u00e9is c\u00faltaca a chruth\u00fa\nsha256sum prod_db_backup.tar.gz > prod_db_backup.tar.gz.sha256\n\n# An hash a fh\u00edor\u00fa ar an bhfreastala\u00ed st\u00f3r\u00e1la\nsha256sum -c prod_db_backup.tar.gz.sha256\n<\/code><\/pre>\n
Teicn\u00edc\u00ed Bail\u00edochtaithe a Bhaineann go Sonrach le Bunachair Sonra\u00ed<\/h2>\n
Tugann innill \u00e9ags\u00fala bunachar sonra\u00ed uirlis\u00ed d\u00fachasacha chun sl\u00e1ine a n-eiseaml\u00e1ir\u00ed c\u00faltaca a fh\u00edor\u00fa.<\/p>\n
PostgreSQL: pg_verifybackup<\/code><\/h3>\n
Tugadh pg_verifybackup<\/code> isteach i PostgreSQL 13, agus is athr\u00f3ir cluiche \u00e9 do ch\u00faltaca\u00ed fisici\u00fala a t\u00f3gadh le pg_basebackup<\/code>. L\u00e9ann s\u00e9 an comhad backup_manifest<\/code> a ghintear le linn an ch\u00faltaca agus f\u00edora\u00edonn s\u00e9 go bhfuil gach comhad i l\u00e1thair agus go n-aonta\u00edonn a gcuid seice\u00e1lacha suime.<\/p>\n
# Rith f\u00edor\u00fa i gcoinne eolaire c\u00faltaca fisici\u00fail\npg_verifybackup \/mnt\/backups\/postgres\/base_backup_20231025\/\n<\/code><\/pre>\n
M\u00e1 t\u00e1 giot\u00e1n amh\u00e1in smeachta in aon cheann de na comhaid sonra\u00ed, caithfidh pg_verifybackup<\/code> earr\u00e1id mharfach, rud a ligeann do do ch\u00f3rais monat\u00f3ireachta fol\u00e1ireamh a thabhairt don fhoireann DBA l\u00e1ithreach.<\/p>\n
Microsoft SQL Server: RESTORE VERIFYONLY<\/code><\/h3>\n
Sol\u00e1thra\u00edonn SQL Server ord\u00fa d\u00fachasach chun sl\u00e1ine fhisici\u00fail comhad c\u00faltaca a fh\u00edor\u00fa gan \u00e9 a athch\u00f3iri\u00fa i nd\u00e1ir\u00edre. Seice\u00e1lann s\u00e9 ceannt\u00e1sca an ch\u00faltaca agus bail\u00edochta\u00edonn s\u00e9 seice\u00e1lacha suime an leathanaigh (m\u00e1 bh\u00ed siad cumasaithe le linn an ch\u00faltaca).<\/p>\n
RESTORE VERIFYONLY \nFROM DISK = 'Z:BackupsProdDB_Full.bak' \nWITH CHECKSUM;\n<\/code><\/pre>\n
Rabhadh:<\/strong> N\u00ed dheimhn\u00edonn RESTORE VERIFYONLY<\/code> ach go bhfuil an comhad c\u00faltaca inl\u00e9ite agus go n-aonta\u00edonn na seice\u00e1lacha suime fisici\u00fala. N\u00ed r\u00e1tha\u00edonn s\u00e9<\/em> sl\u00e1ine loighci\u00fail. Chun sl\u00e1ine loighci\u00fail a chinnti\u00fa, n\u00ed m\u00f3r duit athch\u00f3iri\u00fa ioml\u00e1n a dh\u00e9anamh agus DBCC CHECKDB<\/code> a rith.<\/p>\n
MySQL \/ InnoDB: Percona XtraBackup<\/h3>\n
I gc\u00e1s timpeallachta\u00ed MySQL, is minic a l\u00e1imhse\u00e1lann Percona XtraBackup c\u00faltaca\u00ed fisici\u00fala. Is \u00e9ard at\u00e1 sa phr\u00f3iseas c\u00faltaca n\u00e1 comhaid a ch\u00f3ipe\u00e1il, ach n\u00ed bh\u00edonn an c\u00faltaca comhsheasmhach go dt\u00ed go gcuirtear na loga\u00ed idirbhirt (redo logs) i bhfeidhm. Feidhm\u00edonn an ch\u00e9im --prepare<\/code> mar sheice\u00e1il sl\u00e1ine ionsuite.<\/p>\n
# Cuireann ullmh\u00fa an ch\u00faltaca na loga\u00ed redo i bhfeidhm. \n# M\u00e1 t\u00e1 an c\u00faltaca truaillithe, teipfidh ar an gc\u00e9im seo.\nxtrabackup --prepare --target-dir=\/data\/backups\/mysql\/\n<\/code><\/pre>\n
An Caighde\u00e1n \u00d3ir: T\u00e1st\u00e1il Athch\u00f3irithe Uathoibrithe<\/h2>\n
T\u00e1 seice\u00e1lacha suime agus orduithe f\u00edoraithe riachtanach, ach n\u00ed leor iad. Is \u00e9 an t-aon bhealach chun a chruth\u00fa go cinnte go bhfuil c\u00faltaca inmharthana n\u00e1 \u00e9 a athch\u00f3iri\u00fa. I dtimpeallachta\u00ed nua-aimseartha DevOps, n\u00ed m\u00f3r an pr\u00f3iseas seo a uathoibri\u00fa go hioml\u00e1n.<\/p>\n
Tr\u00ed ch\u00f3ir a chur ar ch\u00faltaca\u00ed mar ch\u00f3d, is f\u00e9idir leat p\u00edbl\u00edne CI\/CD a th\u00f3g\u00e1il le haghaidh d’athch\u00f3irithe bunachar sonra\u00ed. Ba cheart don ph\u00edbl\u00edne seo bonneagar eifimearach a shol\u00e1thar, an t-athch\u00f3iri\u00fa a fhorghn\u00edomh\u00fa, ceisteanna bail\u00edochtaithe a rith, agus an timpeallacht a scriosadh.<\/p>\n
P\u00edbl\u00edne Athch\u00f3irithe Uathoibrithe a Th\u00f3g\u00e1il<\/h3>\n
Seo th\u00edos sampla de script Bash a d’fh\u00e9adfa\u00ed a spreagadh go laeth\u00fail ag post cron n\u00f3 ag rithire CI (cos\u00fail le GitLab CI n\u00f3 GitHub Actions) chun dump\u00e1il loighci\u00fail PostgreSQL a bhail\u00edocht\u00fa.<\/p>\n
#!\/bin\/bash\nset -e\n\nBACKUP_FILE="\/mnt\/storage\/prod_db_latest.dump"\nDB_NAME="prod_db"\nCONTAINER_NAME="pg_restore_test"\n\necho "[INFO] Ag tos\u00fa T\u00e1st\u00e1il Athch\u00f3irithe Uathoibrithe..."\n\n# 1. Cuir coime\u00e1d\u00e1n eifimearach PostgreSQL ar si\u00fal\ndocker run --name $CONTAINER_NAME \n  -e POSTGRES_PASSWORD=testpass \n  -d postgres:15\n\n# Fan go mbeidh PostgreSQL r\u00e9idh\necho "[INFO] Ag fanacht le bunachar sonra\u00ed a th\u00fas\u00fa..."\nuntil docker exec $CONTAINER_NAME pg_isready -U postgres; do\n  sleep 2\ndone\n\n# 2. Cruthaigh an bunachar sonra\u00ed sprice\ndocker exec $CONTAINER_NAME psql -U postgres -c "CREATE DATABASE $DB_NAME;"\n\n# 3. Forghn\u00edomhaigh an t-athch\u00f3iri\u00fa\necho "[INFO] Ag athch\u00f3iri\u00fa c\u00faltaca..."\ndocker cp $BACKUP_FILE $CONTAINER_NAME:\/tmp\/backup.dump\ndocker exec $CONTAINER_NAME pg_restore -U postgres -d $DB_NAME -1 \/tmp\/backup.dump\n\n# 4. Rith Ceisteanna Bail\u00edochtaithe Loighci\u00fala\necho "[INFO] Ag rith ceisteanna bail\u00edochtaithe..."\n# Seice\u00e1il an bhfuil n\u00edos m\u00f3 n\u00e1 10,000 taifead sa t\u00e1bla \u00fas\u00e1ideoir\u00ed\nUSER_COUNT=$(docker exec $CONTAINER_NAME psql -U postgres -d $DB_NAME -t -c "SELECT COUNT(*) FROM users;")\n\nif [ "$USER_COUNT" -lt 10000 ]; then\n    echo "[ERROR] Theip ar bhail\u00edocht\u00fa loighci\u00fail. Bh\u00edothas ag s\u00fail le >10000 \u00fas\u00e1ideoir, fuarthas $USER_COUNT"\n    # Spreag fol\u00e1ireamh PagerDuty \/ Slack anseo\n    exit 1\nelse\n    echo "[SUCCESS] D'\u00e9irigh leis an mbail\u00edocht\u00fa loighci\u00fail. L\u00edon na n-\u00fas\u00e1ideoir\u00ed: $USER_COUNT"\nfi\n\n# 5. Scrios an timpeallacht eifimearach\necho "[INFO] Ag glanadh suas..."\ndocker rm -f $CONTAINER_NAME\n\necho "[INFO] T\u00e1st\u00e1il Athch\u00f3irithe Uathoibrithe Cr\u00edochnaithe go Rath\u00fail."\n<\/code><\/pre>\n
Cad ba cheart duit a bhail\u00edocht\u00fa?<\/h3>\n
Agus t\u00e1st\u00e1il athch\u00f3irithe uathoibrithe \u00e1 d\u00e9anamh agat, n\u00e1 seice\u00e1il ach an dtosa\u00edonn an bunachar sonra\u00ed. Rith ceisteanna bail\u00edochtaithe a bhaineann go sonrach leis an bhfeidhmchl\u00e1r:
\n1.  L\u00edon na n-asraonta:<\/strong> Cinntigh go bhfuil l\u00edon na n-asraonta ionchais ag t\u00e1bla\u00ed l\u00e1rnacha (m.sh., n\u00edor cheart go mbeadh an t\u00e1bla users<\/code> folamh).
\n2.  Sonra\u00ed le d\u00e9ana\u00ed:<\/strong> D\u00e9an ceist le haghaidh taifead a crutha\u00edodh sna 24 uair an chloig anuas chun a chinnti\u00fa nach bhfuil an c\u00faltaca sean.
\n3.  Sl\u00e1ine Tagartha:<\/strong> Rith scripteanna chun seice\u00e1il le haghaidh eochracha eachtracha d\u00edlleachta, rud a l\u00e9ir\u00edonn truailli\u00fa loighci\u00fail.<\/p>\n
Monat\u00f3ireacht agus Fol\u00e1ireamh le haghaidh Aimhrialtachta\u00ed C\u00faltaca<\/h2>\n
Teasta\u00edonn inbhreathnaitheacht l\u00e1idir chun truailli\u00fa a bhrath sula dtarla\u00edonn tubaiste. Taobh amuigh de st\u00e1it dh\u00e9n\u00e1rtha ratha\/teipe, ba cheart duit monat\u00f3ireacht a dh\u00e9anamh ar mheiteashonra\u00ed do phoist ch\u00faltaca chun aimhrialtachta\u00ed a bhrath.<\/p>\n
Monat\u00f3ireacht Heorastach<\/h3>\n
Comhth\u00e1thaigh do mheiteashonra\u00ed c\u00faltaca isteach i Prometheus agus d\u00e9an iad a l\u00e9irshamhl\u00fa le Grafana. Socraigh fol\u00e1irimh do na heorastaic seo a leanas:
\n*   Titim tobann i m\u00e9id:<\/strong> M\u00e1 t\u00e1 do ch\u00faltaca laeth\u00fail 500GB i gc\u00f3na\u00ed, agus m\u00e1 t\u00e1 c\u00faltaca an lae inniu 50MB, b’fh\u00e9idir gur chr\u00edochnaigh an post go rath\u00fail (Exit Code 0), ach is d\u00f3cha gur ch\u00faltacaigh s\u00e9 sc\u00e9imre folamh.
\n*   Aimhrialtachta\u00ed Fad:<\/strong> M\u00e1 chr\u00edochna\u00edonn c\u00faltaca a th\u00f3gann 2 uair an chloig de ghn\u00e1th i 5 n\u00f3im\u00e9ad, f\u00e1gadh rud \u00e9igin ar l\u00e1r. Os a choinne sin, m\u00e1 th\u00f3gann s\u00e9 10 n-uaire an chloig, b’fh\u00e9idir go bhfuil d\u00edghr\u00e1d\u00fa I\/O diosca agat a d’fh\u00e9adfadh truailli\u00fa a bheith mar thoradh air.
\n*   Carnadh Loga\u00ed WAL\/Cartlainne:<\/strong> M\u00e1 t\u00e1 do bhunachar sonra\u00ed ag gini\u00faint Loga\u00ed Write-Ahead (WAL) ach nach bhfuil an c\u00f3ras c\u00faltaca \u00e1 gcartlann\u00fa go tapa go leor, t\u00e1 baol ann go mbeidh bearna i do shlabhra Aisghabh\u00e1la Point-in-Time (PITR).<\/p>\n
Riail 3-2-1 a Chur i bhFeidhm le Seice\u00e1lacha Sl\u00e1ine<\/h2>\n
N\u00edl an riail ch\u00faltaca 3-2-1 at\u00e1 mar chaighde\u00e1n tionscail (3 ch\u00f3ip de shonra\u00ed, 2 mhe\u00e1n \u00e9ags\u00fala, 1 lasmuigh den l\u00e1thair) \u00e9ifeachtach ach amh\u00e1in m\u00e1 dh\u00e9antar gach c\u00f3ip a fh\u00edor\u00fa.<\/p>\n
Seo an \u00e1it a laghda\u00edonn \u00fas\u00e1id a bhaint as r\u00e9iteach fiontair cos\u00fail le CloudSave an t-ualach oibri\u00fach\u00e1in go m\u00f3r. In ionad scripteanna bash casta a scr\u00edobh agus a chothabh\u00e1il do gach n\u00f3d bunachar sonra\u00ed, comhth\u00e1tha\u00edonn CloudSave go d\u00edreach le do bhonneagar chun an timthriall 3-2-1 a uathoibri\u00fa. Sol\u00e1thra\u00edonn s\u00e9 st\u00f3r\u00e1il dho-athraithe\u2014ag cosaint i gcoinne ransomware\u2014agus t\u00e1 sceidil f\u00edoraithe athch\u00f3irithe uathoibrithe ionsuite ann. Is f\u00e9idir le CloudSave timpeallachta\u00ed bosca gainimh scoite a chur ar si\u00fal go huathoibr\u00edoch, an c\u00faltaca a chur suas, do scripteanna bail\u00edochtaithe SQL saincheaptha a rith, agus st\u00e1das na sl\u00e1inte a thuairisci\u00fa ar ais chuig do dheais l\u00e1rnach.<\/p>\n
Concl\u00faid<\/h2>\n
Is marf\u00f3ir ci\u00fain iad c\u00faltaca\u00ed bunachar sonra\u00ed truaillithe ar f\u00e9idir leo gn\u00f3lachta\u00ed a scriosadh. Is geall cont\u00fairteach \u00e9 brath go hioml\u00e1n ar Exit Code 0<\/code> script ch\u00faltaca.<\/p>\n
Chun do thimpeallachta\u00ed t\u00e1irgthe a chosaint i nd\u00e1ir\u00edre, n\u00ed m\u00f3r duit strait\u00e9is cosanta i ndoimhneacht a ghlacadh:
\n1.  Cumasaigh seice\u00e1lacha suime ar leibh\u00e9al an leathanaigh laistigh de d’inneall bunachar sonra\u00ed.
\n2.  \u00das\u00e1id uirlis\u00ed f\u00edoraithe d\u00fachasacha (pg_verifybackup<\/code>, RESTORE VERIFYONLY<\/code>) d\u00edreach tar \u00e9is c\u00faltaca a chruth\u00fa.
\n3.  D\u00e9an monat\u00f3ireacht ar mheiteashonra\u00ed c\u00faltaca (m\u00e9id, fad) le haghaidh aimhrialtachta\u00ed heorastacha.
\n4.  Cuir t\u00e1st\u00e1il athch\u00f3irithe uathoibrithe, eifimearach i bhfeidhm mar chuid de do ph\u00edbl\u00edne oibri\u00fach\u00e1in laeth\u00fail.<\/p>\n
Tr\u00ed aistri\u00fa \u00f3 mheon c\u00faltaca \u00e9ighn\u00edomhach “d\u00f3igh agus dearmad” go m\u00fanla “bail\u00edocht\u00fa athch\u00f3irithe lean\u00fanach” gn\u00edomhach, cinnt\u00edonn t\u00fa nuair a tharla\u00edonn tubaiste go dosheachanta, go bhfuil do shonra\u00ed r\u00e9idh, iontaofa, agus inathch\u00f3irithe go hioml\u00e1n.<\/p>\n","protected":false},"excerpt":{"rendered":"
** Discover how DevOps engineers and DBAs can detect corrupted database backups before disaster strikes. Learn advanced techniques for PostgreSQL, SQL Server, and MySQL, including automated restore testing and checksum validation.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"Detect Corrupted Database Backups Before Disaster","rank_math_description":"** Discover how DevOps engineers and DBAs can detect corrupted database backups before disaster strikes. Learn advanced techniques for PostgreSQL, SQL Server, and MySQL, including automated restore testing and checksum validation.","rank_math_focus_keyword":"corrupted database backups","footnotes":""},"categories":[495],"tags":[3378,3379,3380,496,990,2227,3381],"class_list":["post-4679","post","type-post","status-publish","format-standard","hentry","category-database-backup","tag-backup-testing","tag-corrupted-backups","tag-data-integrity","tag-data-loss-prevention","tag-database-administration","tag-devops","tag-restore-testing"],"yoast_head":"\nDetect Corrupted Database Backups Before Disaster<\/title>\n<meta name=\"description\" content=\"** Discover how DevOps engineers and DBAs can detect corrupted database backups before disaster strikes. Learn advanced techniques for PostgreSQL, SQL Server, and MySQL, including automated restore testing and checksum validation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"An D\u00fanmharf\u00f3ir Ci\u00fain: Conas C\u00faltaca\u00ed Bunachar Sonra\u00ed \u00c9illithe a Bhrath Sula dTarla\u00edonn Tubaiste\" \/>\n<meta property=\"og:description\" content=\"** Discover how DevOps engineers and DBAs can detect corrupted database backups before disaster strikes. Learn advanced techniques for PostgreSQL, SQL Server, and MySQL, including automated restore testing and checksum validation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/\" \/>\n<meta property=\"og:site_name\" content=\"CloudSave\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-14T19:31:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-15T15:18:07+00:00\" \/>\n<meta name=\"author\" content=\"shervinrv\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"shervinrv\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\\\/\"},\"author\":{\"name\":\"shervinrv\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\"},\"headline\":\"An D\u00fanmharf\u00f3ir Ci\u00fain: Conas C\u00faltaca\u00ed Bunachar Sonra\u00ed \u00c9illithe a Bhrath Sula dTarla\u00edonn Tubaiste\",\"datePublished\":\"2026-06-14T19:31:06+00:00\",\"dateModified\":\"2026-06-15T15:18:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\\\/\"},\"wordCount\":1984,\"publisher\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\"},\"keywords\":[\"backup testing\",\"corrupted backups\",\"data integrity\",\"data loss prevention\",\"Database Administration\",\"devops\",\"restore testing\"],\"articleSection\":[\"Database Backup\"],\"inLanguage\":\"ga\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\\\/\",\"url\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\\\/\",\"name\":\"Detect Corrupted Database Backups Before Disaster\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/#website\"},\"datePublished\":\"2026-06-14T19:31:06+00:00\",\"dateModified\":\"2026-06-15T15:18:07+00:00\",\"description\":\"** Discover how DevOps engineers and DBAs can detect corrupted database backups before disaster strikes. Learn advanced techniques for PostgreSQL, SQL Server, and MySQL, including automated restore testing and checksum validation.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\\\/#breadcrumb\"},\"inLanguage\":\"ga\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"An D\u00fanmharf\u00f3ir Ci\u00fain: Conas C\u00faltaca\u00ed Bunachar Sonra\u00ed \u00c9illithe a Bhrath Sula dTarla\u00edonn Tubaiste\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/#website\",\"url\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/\",\"name\":\"CloudSave\",\"description\":\"CloudSave\",\"publisher\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ga\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\",\"name\":\"shervinrv\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ga\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Logo_Name-2.png\",\"url\":\"https:\\\/\\\/cloudsave.app\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Logo_Name-2.png\",\"contentUrl\":\"https:\\\/\\\/cloudsave.app\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Logo_Name-2.png\",\"width\":859,\"height\":150,\"caption\":\"shervinrv\"},\"logo\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Logo_Name-2.png\"},\"sameAs\":[\"http:\\\/\\\/cloudsave.app\"],\"url\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/author\\\/shervinrv\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Detect Corrupted Database Backups Before Disaster","description":"** Discover how DevOps engineers and DBAs can detect corrupted database backups before disaster strikes. Learn advanced techniques for PostgreSQL, SQL Server, and MySQL, including automated restore testing and checksum validation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/","og_locale":"en_US","og_type":"article","og_title":"An D\u00fanmharf\u00f3ir Ci\u00fain: Conas C\u00faltaca\u00ed Bunachar Sonra\u00ed \u00c9illithe a Bhrath Sula dTarla\u00edonn Tubaiste","og_description":"** Discover how DevOps engineers and DBAs can detect corrupted database backups before disaster strikes. Learn advanced techniques for PostgreSQL, SQL Server, and MySQL, including automated restore testing and checksum validation.","og_url":"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/","og_site_name":"CloudSave","article_published_time":"2026-06-14T19:31:06+00:00","article_modified_time":"2026-06-15T15:18:07+00:00","author":"shervinrv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"shervinrv","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/#article","isPartOf":{"@id":"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/"},"author":{"name":"shervinrv","@id":"https:\/\/cloudsave.app\/ga\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d"},"headline":"An D\u00fanmharf\u00f3ir Ci\u00fain: Conas C\u00faltaca\u00ed Bunachar Sonra\u00ed \u00c9illithe a Bhrath Sula dTarla\u00edonn Tubaiste","datePublished":"2026-06-14T19:31:06+00:00","dateModified":"2026-06-15T15:18:07+00:00","mainEntityOfPage":{"@id":"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/"},"wordCount":1984,"publisher":{"@id":"https:\/\/cloudsave.app\/ga\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d"},"keywords":["backup testing","corrupted backups","data integrity","data loss prevention","Database Administration","devops","restore testing"],"articleSection":["Database Backup"],"inLanguage":"ga"},{"@type":"WebPage","@id":"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/","url":"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/","name":"Detect Corrupted Database Backups Before Disaster","isPartOf":{"@id":"https:\/\/cloudsave.app\/ga\/#website"},"datePublished":"2026-06-14T19:31:06+00:00","dateModified":"2026-06-15T15:18:07+00:00","description":"** Discover how DevOps engineers and DBAs can detect corrupted database backups before disaster strikes. Learn advanced techniques for PostgreSQL, SQL Server, and MySQL, including automated restore testing and checksum validation.","breadcrumb":{"@id":"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/#breadcrumb"},"inLanguage":"ga","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cloudsave.app\/ga\/knowledge-base\/an-d%c3%banmharf%c3%b3ir-ci%c3%bain-conas-c%c3%baltaca%c3%ad-bunachar-sonra%c3%ad-%c3%a9illithe-a-bhrath-sula-dtarla%c3%adonn-tubaiste\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudsave.app\/ga\/"},{"@type":"ListItem","position":2,"name":"An D\u00fanmharf\u00f3ir Ci\u00fain: Conas C\u00faltaca\u00ed Bunachar Sonra\u00ed \u00c9illithe a Bhrath Sula dTarla\u00edonn Tubaiste"}]},{"@type":"WebSite","@id":"https:\/\/cloudsave.app\/ga\/#website","url":"https:\/\/cloudsave.app\/ga\/","name":"CloudSave","description":"CloudSave","publisher":{"@id":"https:\/\/cloudsave.app\/ga\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cloudsave.app\/ga\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ga"},{"@type":["Person","Organization"],"@id":"https:\/\/cloudsave.app\/ga\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d","name":"shervinrv","image":{"@type":"ImageObject","inLanguage":"ga","@id":"https:\/\/cloudsave.app\/wp-content\/uploads\/2026\/02\/Logo_Name-2.png","url":"https:\/\/cloudsave.app\/wp-content\/uploads\/2026\/02\/Logo_Name-2.png","contentUrl":"https:\/\/cloudsave.app\/wp-content\/uploads\/2026\/02\/Logo_Name-2.png","width":859,"height":150,"caption":"shervinrv"},"logo":{"@id":"https:\/\/cloudsave.app\/wp-content\/uploads\/2026\/02\/Logo_Name-2.png"},"sameAs":["http:\/\/cloudsave.app"],"url":"https:\/\/cloudsave.app\/ga\/knowledge-base\/author\/shervinrv\/"}]}},"_links":{"self":[{"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/posts\/4679","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/comments?post=4679"}],"version-history":[{"count":2,"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/posts\/4679\/revisions"}],"predecessor-version":[{"id":5745,"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/posts\/4679\/revisions\/5745"}],"wp:attachment":[{"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/media?parent=4679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/categories?post=4679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/tags?post=4679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}