{"id":5902,"date":"2026-06-16T16:15:28","date_gmt":"2026-06-16T16:15:28","guid":{"rendered":"https:\/\/cloudsave.app\/knowledge-base\/mssql-transaction-log-full-recovery\/"},"modified":"2026-06-16T16:50:45","modified_gmt":"2026-06-16T16:50:45","slug":"mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar","status":"publish","type":"post","link":"https:\/\/cloudsave.app\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/","title":{"rendered":"MSSQL f\u00e6rsluskr\u00e1 full: Forvarnir og a\u00f0fer\u00f0ir til skj\u00f3trar endurheimtar"},"content":{"rendered":"

Fyrir gagnagrunnsstj\u00f3ra (DBA) og DevOps-verkfr\u00e6\u00f0inga sem st\u00fdra Microsoft SQL Server, eru f\u00e1ar vi\u00f0varanir sem valda jafn miklum kv\u00ed\u00f0a og Villa 9002: The transaction log for database ‘X’ is full<\/em> (F\u00e6rsluskr\u00e1 fyrir gagnagrunninn ‘X’ er full). \u00deegar f\u00e6rsluskr\u00e1in fyllist og getur ekki st\u00e6kka\u00f0, ver\u00f0ur gagnagrunnurinn \u00ed raun skrifvarinn. Allar INSERT<\/code>, UPDATE<\/code> og DELETE<\/code> a\u00f0ger\u00f0ir st\u00f6\u00f0vast, f\u00e6rslur \u00ed forritum mistakast og framlei\u00f0sluumhverfi\u00f0 st\u00f6\u00f0vast algj\u00f6rlega.<\/p>\n

A\u00f0 skilja undirliggjandi arkitekt\u00far SQL Server f\u00e6rsluskr\u00e1rinnar, greina r\u00f3t vandans n\u00e1kv\u00e6mlega og framkv\u00e6ma skj\u00f3t vi\u00f0ger\u00f0arferli eru mikilv\u00e6gir h\u00e6fileikar til a\u00f0 vi\u00f0halda mikilli frambo\u00f0sgetu (high availability). \u00deessi \u00edtarlega handb\u00f3k kannar v\u00e9lfr\u00e6\u00f0i f\u00e6rsluskr\u00e1rinnar, hvernig \u00e1 a\u00f0 leysa \u00far fullri skr\u00e1 \u00ed ney\u00f0artilvikum og bestu starfsvenjur \u00ed arkitekt\u00far til a\u00f0 koma \u00ed veg fyrir a\u00f0 \u00feetta gerist aftur.<\/p>\n

Skilningur \u00e1 arkitekt\u00far SQL Server f\u00e6rsluskr\u00e1r<\/h2>\n

Til a\u00f0 leysa vandam\u00e1l me\u00f0 fulla f\u00e6rsluskr\u00e1 \u00e1 \u00e1hrifar\u00edkan h\u00e1tt ver\u00f0ur \u00fe\u00fa fyrst a\u00f0 skilja hvernig SQL Server skrifar og st\u00fdrir g\u00f6gnum.<\/p>\n

Write-Ahead Logging (WAL)<\/h3>\n

SQL Server notar Write-Ahead Logging (WAL) samskiptareglur. Hven\u00e6r sem gagnabreyting \u00e1 s\u00e9r sta\u00f0 er breytingin fyrst skrifu\u00f0 \u00ed f\u00e6rsluskr\u00e1na \u00ed minni, s\u00ed\u00f0an skolu\u00f0 yfir \u00ed l\u00edkamlegu skr\u00e1na \u00e1 disknum \u00e1\u00f0ur en raunverulegar gagnas\u00ed\u00f0ur eru uppf\u00e6r\u00f0ar \u00ed gagnagrunnsskr\u00e1num (MDF\/NDF). \u00deetta tryggir ACID (Atomicity, Consistency, Isolation, Durability) samr\u00e6mi, sem tryggir a\u00f0 ef hrun ver\u00f0ur geti SQL Server spila\u00f0 aftur (roll forward) e\u00f0a afturkalla\u00f0 (roll back) f\u00e6rslur.<\/p>\n

Virtual Log Files (VLFs) og hringr\u00e1sarskr\u00e1ning<\/h3>\n

Innan fr\u00e1 er l\u00edkamlega f\u00e6rsluskr\u00e1rskr\u00e1in (LDF) skipt \u00ed sm\u00e6rri, r\u00f6kr\u00e9tta hluta sem kallast Virtual Log Files (VLFs). F\u00e6rsluskr\u00e1in starfar \u00ed hringr\u00e1s. Eftir \u00fev\u00ed sem f\u00e6rsluskr\u00e1arf\u00e6rslur eru skrifa\u00f0ar fylla \u00fe\u00e6r eina VLF og f\u00e6ra sig yfir \u00ed \u00fe\u00e1 n\u00e6stu.<\/p>\n

\u00deegar skr\u00e1in n\u00e6r enda l\u00edkamlegu skr\u00e1rinnar reynir h\u00fan a\u00f0 byrja aftur \u00e1 upphafinu. Hins vegar getur h\u00fan a\u00f0eins skrifa\u00f0 yfir VLF ef s\u00fa VLF er merkt sem \u00f3virk<\/strong> (inactive). Ef allar VLFs eru virkar (sem \u00fe\u00fd\u00f0ir a\u00f0 \u00fe\u00e6r innihalda f\u00e6rslur sem SQL Server \u00fearf enn \u00e1 a\u00f0 halda), getur skr\u00e1in ekki byrja\u00f0 upp \u00e1 n\u00fdtt. Ef sj\u00e1lfvirk st\u00e6kkun (auto-growth) er virkju\u00f0 og diskpl\u00e1ss er \u00ed bo\u00f0i, st\u00e6kkar l\u00edkamlega skr\u00e1in. Ef diskurinn er fullur e\u00f0a sj\u00e1lfvirk st\u00e6kkun er takm\u00f6rku\u00f0, lendir \u00fe\u00fa \u00ed Villu 9002.<\/p>\n

F\u00e6rsluskr\u00e1arhreinsun (Truncation) vs. F\u00e6rsluskr\u00e1arsamdr\u00e1ttur (Shrinking)<\/h3>\n

Algengur misskilningur er a\u00f0 hreinsun (truncation) f\u00e6rsluskr\u00e1rinnar minnki l\u00edkamlega st\u00e6r\u00f0 skr\u00e1rinnar.
\n* F\u00e6rsluskr\u00e1arhreinsun:<\/strong> Ferli\u00f0 vi\u00f0 a\u00f0 merkja virkar VLFs sem \u00f3virkar, sem gerir pl\u00e1ssi\u00f0 tilt\u00e6kt til endurnotkunar. \u00dea\u00f0 minnkar ekki<\/em> st\u00e6r\u00f0 LDF-skr\u00e1rinnar \u00e1 disknum.
\n* F\u00e6rsluskr\u00e1arsamdr\u00e1ttur:<\/strong> Ferli\u00f0 vi\u00f0 a\u00f0 minnka l\u00edkamlega st\u00e6r\u00f0 LDF-skr\u00e1rinnar og skila pl\u00e1ssi til st\u00fdrikerfisins.<\/p>\n

\u00cd Full Recovery l\u00edkaninu \u00e1 f\u00e6rsluskr\u00e1arhreinsun a\u00f0eins<\/em> s\u00e9r sta\u00f0 \u00feegar afritun f\u00e6rsluskr\u00e1r (transaction log backup) hefur veri\u00f0 loki\u00f0 me\u00f0 g\u00f3\u00f0um \u00e1rangri (a\u00f0 \u00fev\u00ed gefnu a\u00f0 engin \u00f6nnur ferli haldi skr\u00e1nni virkri).<\/p>\n

Greining \u00e1 \u201eTransaction Log Full\u201c villunni (Villa 9002)<\/h2>\n

\u00deegar skr\u00e1in er full er fyrsta skrefi\u00f0 ekki a\u00f0 b\u00e6ta vi\u00f0 diskpl\u00e1ssi e\u00f0a minnka skr\u00e1r \u00ed blindni. \u00de\u00fa ver\u00f0ur a\u00f0 bera kennsl \u00e1 hvers vegna<\/em> skr\u00e1in getur ekki hreinsa\u00f0 sig. SQL Server b\u00fd\u00f0ur upp \u00e1 innbygg\u00f0an b\u00fana\u00f0 til a\u00f0 segja \u00fe\u00e9r n\u00e1kv\u00e6mlega hva\u00f0 kemur \u00ed veg fyrir endurnotkun skr\u00e1rinnar \u00ed gegnum sys.databases<\/code> v\u00f6rulistas\u00fdnina.<\/p>\n

Keyr\u00f0u eftirfarandi T-SQL skipun til a\u00f0 bera kennsl \u00e1 fl\u00f6skuh\u00e1lsinn:<\/p>\n

SELECT \n    name AS DatabaseName, \n    recovery_model_desc AS RecoveryModel, \n    log_reuse_wait_desc AS LogReuseWaitReason\nFROM sys.databases\nWHERE name = 'YourDatabaseName';\n<\/code><\/pre>\n
\u00de\u00fa getur l\u00edka athuga\u00f0 n\u00faverandi pl\u00e1ssnotkun f\u00e6rsluskr\u00e1rinnar me\u00f0 \u00fev\u00ed a\u00f0 nota:<\/p>\n
DBCC SQLPERF(LOGSPACE);\n<\/code><\/pre>\n
Algengar log_reuse_wait_desc<\/code> st\u00f6\u00f0ur<\/h3>\n
    \n
  1. LOG_BACKUP:<\/strong> Gagnagrunnurinn er \u00ed Full e\u00f0a Bulk-Logged endurheimtarl\u00edkani og afritun f\u00e6rsluskr\u00e1r hefur ekki veri\u00f0 tekin n\u00fdlega. \u00deetta er algengasta ors\u00f6kin.<\/li>\n
  2. ACTIVE_TRANSACTION:<\/strong> Langvarandi f\u00e6rsla (t.d. gr\u00ed\u00f0arleg endurbygging \u00e1 v\u00edsit\u00f6lu e\u00f0a gleymd \u00f3sta\u00f0fest f\u00e6rsla) heldur skr\u00e1nni virkri.<\/li>\n
  3. REPLICATION \/ CDC:<\/strong> Transactional Replication e\u00f0a Change Data Capture (CDC) er virkt og Log Reader Agent hefur ekki enn unni\u00f0 \u00far f\u00e6rslunum.<\/li>\n
  4. AVAILABILITY_REPLICA:<\/strong> \u00cd AlwaysOn Availability Group er auka-afrit (secondary replica) aftengt e\u00f0a samstillist of h\u00e6gt, sem ney\u00f0ir a\u00f0alafriti\u00f0 til a\u00f0 halda \u00ed f\u00e6rsluskr\u00e1arf\u00e6rslur \u00fear til \u00fe\u00e6r hafa veri\u00f0 sta\u00f0festar \u00e1 auka-afritinu.<\/li>\n<\/ol>\n
    Skj\u00f3tar vi\u00f0ger\u00f0ara\u00f0fer\u00f0ir: A\u00f0 leysa vandam\u00e1li\u00f0 \u00ed framlei\u00f0slu<\/h2>\n
    Eftir \u00fev\u00ed hva\u00f0a log_reuse_wait_desc<\/code> er skila\u00f0, ver\u00f0a ney\u00f0arr\u00e1\u00f0stafanir \u00fe\u00ednar mismunandi. H\u00e9r eru skj\u00f3tar vi\u00f0ger\u00f0ara\u00f0fer\u00f0ir fyrir algengustu a\u00f0st\u00e6\u00f0ur.<\/p>\n
    A\u00f0st\u00e6\u00f0ur 1: Vantar afritun f\u00e6rsluskr\u00e1r e\u00f0a h\u00fan mistekst (LOG_BACKUP<\/code>)<\/h3>\n
    Ef bi\u00f0tegundin er LOG_BACKUP<\/code> er lausnin einf\u00f6ld: \u00fe\u00fa ver\u00f0ur a\u00f0 taka afrit af f\u00e6rsluskr\u00e1nni.<\/p>\n
    BACKUP LOG [YourDatabaseName] \nTO DISK = 'N:BackupsYourDatabaseName_EmergencyLog.trn' \nWITH COMPRESSION, STATS = 10;\n<\/code><\/pre>\n
    \u00deegar afrituninni er loki\u00f0 ver\u00f0a \u00f3virkar VLFs hreinsa\u00f0ar og SQL Server mun halda \u00e1fram e\u00f0lilegri starfsemi. Ef afritunardiskurinn \u00feinn er fullur g\u00e6tir\u00f0u \u00feurft a\u00f0 taka afrit \u00e1 t\u00edmabundna netdrif e\u00f0a null-t\u00e6ki (ekki m\u00e6lt me\u00f0 nema gagnagrunnurinn s\u00e9 au\u00f0veldlega endurgeranlegur, \u00fear sem \u00fea\u00f0 r\u00fdfur f\u00e6rsluke\u00f0juna):<\/p>\n
    -- VI\u00d0V\u00d6RUN: \u00deetta r\u00fdfur f\u00e6rsluke\u00f0juna og sker\u00f0ir m\u00f6guleika \u00e1 endurheimt a\u00f0 \u00e1kve\u00f0num t\u00edmapunkti.\n-- Nota\u00f0u a\u00f0eins ef algj\u00f6rlega nau\u00f0synlegt og fylgdu strax eftir me\u00f0 FULLU afriti.\nBACKUP LOG [YourDatabaseName] TO DISK = 'NUL';\n<\/code><\/pre>\n
    A\u00f0st\u00e6\u00f0ur 2: Langvarandi virkar f\u00e6rslur (ACTIVE_TRANSACTION<\/code>)<\/h3>\n
    Ef ein f\u00e6rsla hefur veri\u00f0 \u00ed gangi \u00ed marga klukkut\u00edma kemur h\u00fan \u00ed veg fyrir hreinsun f\u00e6rsluskr\u00e1rinnar allan \u00feann t\u00edma. Fyrst skaltu bera kennsl \u00e1 f\u00e6rsluna sem veldur vandr\u00e6\u00f0um:<\/p>\n
    DBCC OPENTRAN('YourDatabaseName');\n<\/code><\/pre>\n
    \u00deessi skipun skilar elstu virku f\u00e6rslunni og Server Process ID (SPID) hennar. \u00de\u00fa getur safna\u00f0 frekari uppl\u00fdsingum um hva\u00f0 SPID-i\u00f0 er a\u00f0 gera me\u00f0 \u00fev\u00ed a\u00f0 fyrirspyrja dynamic management views (DMVs):<\/p>\n
    SELECT \n    s.session_id,\n    s.login_name,\n    s.host_name,\n    r.start_time,\n    r.status,\n    r.command,\n    t.text AS QueryText\nFROM sys.dm_exec_sessions s\nJOIN sys.dm_exec_requests r ON s.session_id = r.session_id\nCROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t\nWHERE s.session_id = <SPID_FROM_DBCC_OPENTRAN>;\n<\/code><\/pre>\n
    Ef f\u00e6rslan er \u00f3\u00e6skileg fyrirspurn e\u00f0a fast ferli g\u00e6tir\u00f0u \u00feurft a\u00f0 st\u00f6\u00f0va hana til a\u00f0 losa um skr\u00e1na.<\/p>\n
    KILL <SPID>;\n<\/code><\/pre>\n
    Athugi\u00f0: A\u00f0 st\u00f6\u00f0va (KILL) gr\u00ed\u00f0arlega st\u00f3ra f\u00e6rslu mun kalla fram afturk\u00f6llun (rollback), sem getur teki\u00f0 verulegan t\u00edma og mun t\u00edmabundi\u00f0 b\u00faa til vi\u00f0b\u00f3tar f\u00e6rsluskr\u00e1arvirkni. Ekki endurr\u00e6sa SQL Server \u00fej\u00f3nustuna me\u00f0an \u00e1 afturk\u00f6llun stendur, annars mun gagnagrunnurinn fara \u00ed endurheimtarham vi\u00f0 endurr\u00e6singu.<\/em><\/p>\n
    A\u00f0st\u00e6\u00f0ur 3: Ney\u00f0ar\u00fathlutun pl\u00e1sss (Diskur er 100% fullur)<\/h3>\n
    Ef LDF-skr\u00e1in hefur eytt \u00f6llu pl\u00e1ssi \u00e1 drifinu getur\u00f0u ekki einu sinni keyrt afritun \u00fev\u00ed SQL Server \u00fearf sm\u00e1vegis af f\u00e6rsluskr\u00e1arpl\u00e1ssi til a\u00f0 skr\u00e1 sj\u00e1lfan afritunarvi\u00f0bur\u00f0inn. \u00cd \u00feessum a\u00f0st\u00e6\u00f0um ver\u00f0ur \u00fe\u00fa a\u00f0 b\u00e6ta vi\u00f0 aukaf\u00e6rsluskr\u00e1 \u00e1 \u00f6\u00f0ru drifi me\u00f0 lausu pl\u00e1ssi.<\/p>\n
    ALTER DATABASE [YourDatabaseName]\nADD LOG FILE \n(\n    NAME = N'YourDatabaseName_Log2',\n    FILENAME = N'E:TempLogsYourDatabaseName_Log2.ldf',\n    SIZE = 5GB,\n    MAXSIZE = 50GB,\n    FILEGROWTH = 1GB\n);\n<\/code><\/pre>\n
    \u00deetta veitir SQL Server strax svigr\u00fam. \u00deegar gagnagrunnurinn er kominn \u00e1 neti\u00f0 skaltu taka afrit af f\u00e6rsluskr\u00e1nni, t\u00e6ma aukaf\u00e6rsluskr\u00e1na og fjarl\u00e6gja hana:<\/p>\n
    -- 1. Taktu afrit af f\u00e6rsluskr\u00e1 til a\u00f0 hreinsa hana\nBACKUP LOG [YourDatabaseName] TO DISK = '...';\n\n-- 2. T\u00e6mdu t\u00edmabundnu f\u00e6rsluskr\u00e1na\nDBCC SHRINKFILE (N'YourDatabaseName_Log2', EMPTYFILE);\n\n-- 3. Fjarl\u00e6g\u00f0u t\u00edmabundnu f\u00e6rsluskr\u00e1na\nALTER DATABASE [YourDatabaseName] REMOVE FILE [YourDatabaseName_Log2];\n<\/code><\/pre>\n
    Bestu starfsvenjur fyrir forvarnir og stj\u00f3rnun f\u00e6rsluskr\u00e1r<\/h2>\n
    Vi\u00f0brag\u00f0smi\u00f0u\u00f0 bilanaleit er streituvaldandi og hefur \u00e1hrif \u00e1 \u00fej\u00f3nustustig (SLAs). Innlei\u00f0ing \u00e1 fyrirbyggjandi arkitekt\u00far og rekstrarvenjum er nau\u00f0synleg fyrir st\u00f6\u00f0ugleika gagnagrunna \u00ed fyrirt\u00e6kjum.<\/p>\n
    1. Innlei\u00f0a \u00f6fluga, sj\u00e1lfvirka afritunarstefnu<\/h3>\n
    Ef gagnagrunnur er \u00ed Full recovery l\u00edkani er t\u00ed\u00f0 afritun f\u00e6rsluskr\u00e1r skylda. \u00dea\u00f0 fer eftir Recovery Point Objective (RPO) og f\u00e6rslumagni, en afritun f\u00e6rsluskr\u00e1r \u00e6tti a\u00f0 eiga s\u00e9r sta\u00f0 \u00e1 5 til 15 m\u00edn\u00fatna fresti.<\/p>\n
    Afritunarlausnir fyrir fyrirt\u00e6ki eins og CloudSave einfalda \u00feetta ferli verulega. Me\u00f0 \u00fev\u00ed a\u00f0 sam\u00fe\u00e6ttast beint vi\u00f0 SQL Server \u00ed gegnum VDI (Virtual Device Interface), gerir CloudSave gagnagrunnsstj\u00f3rum kleift a\u00f0 stilla stefnumi\u00f0a\u00f0ar, h\u00e1t\u00ed\u00f0ni afritanir \u00e1 f\u00e6rsluskr\u00e1m. \u00deetta tryggir a\u00f0 skr\u00e1r s\u00e9u st\u00f6\u00f0ugt hreinsa\u00f0ar, dulk\u00f3\u00f0a\u00f0ar \u00e1 \u00f6ruggan h\u00e1tt og geymdar utan sta\u00f0setningar e\u00f0a \u00ed \u00f3breytanlegri sk\u00fdjageymslu, sem kemur \u00ed veg fyrir LOG_BACKUP<\/code> bi\u00f0st\u00f6\u00f0una \u00e1n \u00feess a\u00f0 krefjast fl\u00f3kinna s\u00e9rsni\u00f0inna SQL Agent verka.<\/p>\n
    2. R\u00e9tt st\u00e6r\u00f0 \u00e1 f\u00e6rsluskr\u00e1 og stj\u00f3rnun VLFs<\/h3>\n
    A\u00f0 treysta \u00e1 sj\u00e1lfvirka st\u00e6kkun (auto-growth) til a\u00f0 stj\u00f3rna st\u00e6r\u00f0 f\u00e6rsluskr\u00e1rinnar er h\u00e6ttulegt mynstur. Sj\u00e1lfvirkar st\u00e6kkunara\u00f0ger\u00f0ir eru d\u00fdrar og gera hl\u00e9 \u00e1 vinnslu f\u00e6rslna \u00e1 me\u00f0an diskurinn er n\u00fallstilltur (nema Instant File Initialization s\u00e9 virkt, sem \u00e1 ekki<\/em> vi\u00f0 um f\u00e6rsluskr\u00e1r).<\/p>\n
    Ennfremur lei\u00f0a t\u00ed\u00f0ar, litlar sj\u00e1lfvirkar st\u00e6kkanir (t.d. a\u00f0 st\u00e6kka um 10% e\u00f0a 50MB \u00ed einu) til VLF-brotunar<\/strong>. F\u00e6rsluskr\u00e1 me\u00f0 \u00fe\u00fasundum p\u00ednulitlum VLFs mun draga verulega \u00far r\u00e6singart\u00edma gagnagrunns, afritunarafk\u00f6stum og t\u00f6fum \u00e1 afritun (replication latency).<\/p>\n
      \n
    • Forstilltu st\u00e6r\u00f0 skr\u00e1rinnar:<\/strong> Greindu st\u00e6rstu vi\u00f0haldsa\u00f0ger\u00f0ir \u00fe\u00ednar (eins og endurbyggingu v\u00edsitalna) og forstilltu st\u00e6r\u00f0 LDF-skr\u00e1rinnar til a\u00f0 r\u00fama \u00fe\u00e6r \u00e1n \u00feess a\u00f0 \u00feurfa a\u00f0 st\u00e6kka.<\/li>\n
    • Stilltu fasta sj\u00e1lfvirka st\u00e6kkun:<\/strong> Breyttu sj\u00e1lfvirkri st\u00e6kkun \u00far hlutfalli \u00ed fasta st\u00e6r\u00f0 (t.d. 1GB e\u00f0a 5GB) til a\u00f0 tryggja a\u00f0 VLFs s\u00e9u b\u00fanar til \u00ed heilbrig\u00f0ri st\u00e6r\u00f0.<\/li>\n<\/ul>\n
      \u00de\u00fa getur athuga\u00f0 VLF-fj\u00f6lda \u00feinn me\u00f0 eftirfarandi fyrirspurn (fyrir SQL Server 2017+):<\/p>\n
      SELECT \n    db_name(database_id) AS DatabaseName,\n    COUNT(vlf_sequence_number) AS VLF_Count\nFROM sys.dm_db_log_info(DB_ID('YourDatabaseName'));\n<\/code><\/pre>\n
      Ef VLF-fj\u00f6ldi \u00feinn er yfir 500, \u00edhuga\u00f0u a\u00f0 b\u00ed\u00f0a eftir r\u00f3legu t\u00edmabili, minnka skr\u00e1na \u00ed l\u00e1gmarksst\u00e6r\u00f0 og st\u00e6kka hana handvirkt aftur \u00ed nau\u00f0synlega st\u00e6r\u00f0 \u00ed st\u00f3rum sk\u00f6mmtum.<\/p>\n
      3. F\u00ednstilltu vi\u00f0haldsa\u00f0ger\u00f0ir v\u00edsitalna<\/h3>\n
      Endurbygging v\u00edsitalna (Index rebuilds) eru a\u00f0ger\u00f0ir sem eru a\u00f0 fullu skr\u00e1\u00f0ar \u00ed f\u00e6rsluskr\u00e1na, jafnvel \u00ed Bulk-Logged recovery l\u00edkaninu (fer eftir tegund v\u00edsit\u00f6lu). A\u00f0 endurbyggja 500GB v\u00edsit\u00f6lu mun b\u00faa til a\u00f0 minnsta kosti 500GB af f\u00e6rsluskr\u00e1arf\u00e6rslum.<\/p>\n
      Til a\u00f0 draga \u00far f\u00e6rsluskr\u00e1ar\u00feenslu vi\u00f0 vi\u00f0hald:
      \n*   Nota\u00f0u SORT_IN_TEMPDB = ON<\/code> \u00feegar \u00fe\u00fa endurbyggir v\u00edsit\u00f6lur. \u00deetta f\u00e6rir flokkunarfasann yfir \u00ed TempDB, sem dregur \u00far \u00e1lagi \u00e1 f\u00e6rsluskr\u00e1 notendagagnagrunnsins.
      \n*   Skiptu \u00far endurbyggingu v\u00edsitalna (rebuilds) yfir \u00ed endurskipulagningu v\u00edsitalna (reorganizes) \u00fear sem \u00fev\u00ed ver\u00f0ur vi\u00f0 komi\u00f0, \u00fear sem endurskipulagning er skilvirkari fyrir f\u00e6rsluskr\u00e1na og h\u00e6gt er a\u00f0 rj\u00fafa hana \u00e1n \u00feess a\u00f0 afturkalla alla a\u00f0ger\u00f0ina.
      \n*   Skiptu st\u00f3rum DELETE<\/code> e\u00f0a UPDATE<\/code> a\u00f0ger\u00f0um \u00ed lotur. \u00cd sta\u00f0 \u00feess a\u00f0 ey\u00f0a 10 millj\u00f3num ra\u00f0a \u00ed einni f\u00e6rslu, eyddu \u00feeim \u00ed 50.000 ra\u00f0a lotum, sta\u00f0festu (commit) og leyf\u00f0u afritun f\u00e6rsluskr\u00e1r a\u00f0 hreinsa skr\u00e1na \u00e1 milli lota.<\/p>\n
      4. Fylgstu me\u00f0 mikilli frambo\u00f0sgetu og afritunart\u00f3p\u00f3l\u00f3g\u00edum<\/h3>\n
      \u00cd AlwaysOn Availability Groups getur a\u00f0alafriti\u00f0 ekki hreinsa\u00f0 skr\u00e1na s\u00edna fyrr en f\u00e6rsluskr\u00e1arf\u00e6rslurnar hafa veri\u00f0 sta\u00f0festar \u00e1 \u00f6llum samstilltum og \u00f3samstilltum auka-afritum.<\/p>\n
      Ef auka-afrit fer af netinu, e\u00f0a ef netbandbreiddin n\u00e6r ekki a\u00f0 halda \u00ed vi\u00f0 f\u00e6rslumyndunarhra\u00f0a a\u00f0alafritsins, mun sendibi\u00f0r\u00f6\u00f0 a\u00f0alafritsins st\u00e6kka og skr\u00e1in mun fyllast (AVAILABILITY_REPLICA<\/code> bi\u00f0tegund).<\/p>\n
      Innleiddu \u00f6flugt eftirlit fyrir SQLServer:Replica > Log Send Queue<\/code> afkastav\u00edsinn. Ef auka-afrit tapast varanlega ver\u00f0ur \u00fe\u00fa a\u00f0 fjarl\u00e6gja \u00fea\u00f0 \u00far Availability Group e\u00f0a st\u00f6\u00f0va gagnaflutning til a\u00f0 leyfa a\u00f0alf\u00e6rsluskr\u00e1nni a\u00f0 hreinsast.<\/p>\n
      Ni\u00f0ursta\u00f0a<\/h2>\n
      A\u00f0 lenda \u00ed fullri f\u00e6rsluskr\u00e1 er eins konar eldsk\u00edrn fyrir gagnagrunnsstj\u00f3ra, en \u00fea\u00f0 \u00fearf ekki a\u00f0 lei\u00f0a til langvarandi ni\u00f0urt\u00edma. Me\u00f0 \u00fev\u00ed a\u00f0 skilja v\u00e9lfr\u00e6\u00f0i Write-Ahead Logging og VLFs getur\u00f0u flj\u00f3tt greint r\u00f3t vandans me\u00f0 sys.databases<\/code> og beitt r\u00e9ttri skj\u00f3tri vi\u00f0ger\u00f0ara\u00f0fer\u00f0.<\/p>\n
      St\u00f6\u00f0ugleiki til langs t\u00edma byggist \u00e1 \u00fev\u00ed a\u00f0 hverfa fr\u00e1 vi\u00f0brag\u00f0smi\u00f0u\u00f0um lagf\u00e6ringum. A\u00f0 forstilla st\u00e6r\u00f0 f\u00e6rsluskr\u00e1r, f\u00ednstilla vi\u00f0haldsr\u00fat\u00ednur og n\u00fdta afritunarvettvanga fyrir fyrirt\u00e6ki eins og CloudSave til a\u00f0 framfylgja str\u00f6ngum, sj\u00e1lfvirkum afritunar\u00e1\u00e6tlunum mun tryggja a\u00f0 f\u00e6rsluskr\u00e1rnar \u00fe\u00ednar haldist heilbrig\u00f0ar, hreinsa\u00f0ar og tilb\u00fanar til a\u00f0 sty\u00f0ja vi\u00f0 framlei\u00f0slu\u00e1lag me\u00f0 mikilli afkastagetu.<\/p>\n","protected":false},"excerpt":{"rendered":"
      ** Discover expert strategies for preventing and resolving MSSQL transaction log full errors (Error 9002). Learn rapid recovery techniques, VLF management, and architectural best practices for DBAs.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"MSSQL Transaction Log Full: Prevention & Recovery","rank_math_description":"** Discover expert strategies for preventing and resolving MSSQL transaction log full errors (Error 9002). Learn rapid recovery techniques, VLF management, and architectural best practices for DBAs.","rank_math_focus_keyword":"MSSQL transaction log full","footnotes":""},"categories":[479],"tags":[976,4070,4071,4072,4073,4074,4075],"class_list":["post-5902","post","type-post","status-publish","format-standard","hentry","category-database-backup","tag-database-administration","tag-error-9002","tag-log-backup","tag-mssql","tag-sql-recovery","tag-sql-server","tag-transaction-log"],"yoast_head":"\nMSSQL Transaction Log Full: Prevention & Recovery<\/title>\n<meta name=\"description\" content=\"** Discover expert strategies for preventing and resolving MSSQL transaction log full errors (Error 9002). Learn rapid recovery techniques, VLF management, and architectural best practices for DBAs.\" \/>\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\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/\" \/>\n<meta property=\"og:locale\" content=\"is_IS\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MSSQL f\u00e6rsluskr\u00e1 full: Forvarnir og a\u00f0fer\u00f0ir til skj\u00f3trar endurheimtar\" \/>\n<meta property=\"og:description\" content=\"** Discover expert strategies for preventing and resolving MSSQL transaction log full errors (Error 9002). Learn rapid recovery techniques, VLF management, and architectural best practices for DBAs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cloudsave.app\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/\" \/>\n<meta property=\"og:site_name\" content=\"CloudSave\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-16T16:15:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-16T16:50:45+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=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\\\/\"},\"author\":{\"name\":\"shervinrv\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\"},\"headline\":\"MSSQL f\u00e6rsluskr\u00e1 full: Forvarnir og a\u00f0fer\u00f0ir til skj\u00f3trar endurheimtar\",\"datePublished\":\"2026-06-16T16:15:28+00:00\",\"dateModified\":\"2026-06-16T16:50:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\\\/\"},\"wordCount\":1927,\"publisher\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\"},\"keywords\":[\"Database Administration\",\"Error 9002\",\"Log Backup\",\"MSSQL\",\"SQL Recovery\",\"SQL Server\",\"Transaction Log\"],\"articleSection\":[\"Database Backup\"],\"inLanguage\":\"is\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\\\/\",\"url\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\\\/\",\"name\":\"MSSQL Transaction Log Full: Prevention & Recovery\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#website\"},\"datePublished\":\"2026-06-16T16:15:28+00:00\",\"dateModified\":\"2026-06-16T16:50:45+00:00\",\"description\":\"** Discover expert strategies for preventing and resolving MSSQL transaction log full errors (Error 9002). Learn rapid recovery techniques, VLF management, and architectural best practices for DBAs.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\\\/#breadcrumb\"},\"inLanguage\":\"is\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MSSQL f\u00e6rsluskr\u00e1 full: Forvarnir og a\u00f0fer\u00f0ir til skj\u00f3trar endurheimtar\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#website\",\"url\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/\",\"name\":\"CloudSave\",\"description\":\"CloudSave\",\"publisher\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"is\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\",\"name\":\"shervinrv\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"is\",\"@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\\\/is\\\/knowledge-base\\\/author\\\/shervinrv\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MSSQL Transaction Log Full: Prevention & Recovery","description":"** Discover expert strategies for preventing and resolving MSSQL transaction log full errors (Error 9002). Learn rapid recovery techniques, VLF management, and architectural best practices for DBAs.","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\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/","og_locale":"is_IS","og_type":"article","og_title":"MSSQL f\u00e6rsluskr\u00e1 full: Forvarnir og a\u00f0fer\u00f0ir til skj\u00f3trar endurheimtar","og_description":"** Discover expert strategies for preventing and resolving MSSQL transaction log full errors (Error 9002). Learn rapid recovery techniques, VLF management, and architectural best practices for DBAs.","og_url":"https:\/\/cloudsave.app\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/","og_site_name":"CloudSave","article_published_time":"2026-06-16T16:15:28+00:00","article_modified_time":"2026-06-16T16:50:45+00:00","author":"shervinrv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"shervinrv","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/#article","isPartOf":{"@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/"},"author":{"name":"shervinrv","@id":"https:\/\/cloudsave.app\/is\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d"},"headline":"MSSQL f\u00e6rsluskr\u00e1 full: Forvarnir og a\u00f0fer\u00f0ir til skj\u00f3trar endurheimtar","datePublished":"2026-06-16T16:15:28+00:00","dateModified":"2026-06-16T16:50:45+00:00","mainEntityOfPage":{"@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/"},"wordCount":1927,"publisher":{"@id":"https:\/\/cloudsave.app\/is\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d"},"keywords":["Database Administration","Error 9002","Log Backup","MSSQL","SQL Recovery","SQL Server","Transaction Log"],"articleSection":["Database Backup"],"inLanguage":"is"},{"@type":"WebPage","@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/","url":"https:\/\/cloudsave.app\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/","name":"MSSQL Transaction Log Full: Prevention & Recovery","isPartOf":{"@id":"https:\/\/cloudsave.app\/is\/#website"},"datePublished":"2026-06-16T16:15:28+00:00","dateModified":"2026-06-16T16:50:45+00:00","description":"** Discover expert strategies for preventing and resolving MSSQL transaction log full errors (Error 9002). Learn rapid recovery techniques, VLF management, and architectural best practices for DBAs.","breadcrumb":{"@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/#breadcrumb"},"inLanguage":"is","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudsave.app\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/mssql-f%c3%a6rsluskr%c3%a1-full-forvarnir-og-a%c3%b0fer%c3%b0ir-til-skj%c3%b3trar-endurheimtar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudsave.app\/is\/"},{"@type":"ListItem","position":2,"name":"MSSQL f\u00e6rsluskr\u00e1 full: Forvarnir og a\u00f0fer\u00f0ir til skj\u00f3trar endurheimtar"}]},{"@type":"WebSite","@id":"https:\/\/cloudsave.app\/is\/#website","url":"https:\/\/cloudsave.app\/is\/","name":"CloudSave","description":"CloudSave","publisher":{"@id":"https:\/\/cloudsave.app\/is\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cloudsave.app\/is\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"is"},{"@type":["Person","Organization"],"@id":"https:\/\/cloudsave.app\/is\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d","name":"shervinrv","image":{"@type":"ImageObject","inLanguage":"is","@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\/is\/knowledge-base\/author\/shervinrv\/"}]}},"_links":{"self":[{"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/posts\/5902","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/comments?post=5902"}],"version-history":[{"count":1,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/posts\/5902\/revisions"}],"predecessor-version":[{"id":5967,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/posts\/5902\/revisions\/5967"}],"wp:attachment":[{"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/media?parent=5902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/categories?post=5902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/tags?post=5902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}