{"id":5904,"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:52:18","modified_gmt":"2026-06-16T16:52:18","slug":"log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa","status":"publish","type":"post","link":"https:\/\/cloudsave.app\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/","title":{"rendered":"Log Idirbhirt MSSQL L\u00e1n: Strait\u00e9is\u00ed um Chosc agus Aisghabh\u00e1il Thapa"},"content":{"rendered":"

I gc\u00f3ir Riarach\u00e1in Bunachar Sonra\u00ed (DBAanna) agus innealt\u00f3ir\u00ed DevOps a bh\u00edonn ag bainisti\u00fa Microsoft SQL Server, is beag fol\u00e1ireamh a chrutha\u00edonn an oiread sin imn\u00ed l\u00e1ithreach le Earr\u00e1id 9002: T\u00e1 log\u00e1il idirbhirt don bhunachar sonra\u00ed ‘X’ l\u00e1n<\/em>. Nuair a l\u00edontar an log\u00e1il idirbhirt agus nach f\u00e9idir l\u00e9i f\u00e1s, \u00e9ir\u00edonn an bunachar sonra\u00ed inl\u00e9ite amh\u00e1in go h\u00e9ifeachtach. Stopann gach oibr\u00edocht INSERT<\/code>, UPDATE<\/code>, agus DELETE<\/code>, teipeann ar idirbhearta feidhmchl\u00e1ir, agus tagann an t\u00e1irgeadh chun stad ioml\u00e1n.<\/p>\n

Is scileanna r\u00edth\u00e1bhachtacha iad tuiscint a fh\u00e1il ar ailtireacht bhun\u00fasach log\u00e1il idirbhirt SQL Server, diagn\u00f3is chruinn a dh\u00e9anamh ar an mbunch\u00fais, agus n\u00f3sanna imeachta t\u00e9arnaimh tapa a chur i gcr\u00edch chun ard-infhaighteacht a chothabh\u00e1il. Scr\u00fada\u00edonn an treoir chuimsitheach seo meicnic na log\u00e1la idirbhirt, conas log\u00e1il l\u00e1n a r\u00e9iteach i gc\u00e1s \u00e9igeand\u00e1la, agus dea-chleachtais ailtireachta chun cosc a chur air tarl\u00fa ar\u00eds.<\/p>\n

Tuiscint ar Ailtireacht Log\u00e1il Idirbhirt SQL Server<\/h2>\n

Chun fabhtcheart\u00fa \u00e9ifeachtach a dh\u00e9anamh ar log\u00e1il idirbhirt l\u00e1n, n\u00ed m\u00f3r duit ar dt\u00fas tuiscint a fh\u00e1il ar an gcaoi a scr\u00edobhann agus a bhainist\u00edonn SQL Server sonra\u00ed.<\/p>\n

Log\u00e1il R\u00e9amh-Scr\u00edofa (WAL)<\/h3>\n

\u00das\u00e1ideann SQL Server pr\u00f3tacal Log\u00e1la R\u00e9amh-Scr\u00edofa (WAL). Aon uair a tharla\u00edonn modhn\u00fa sonra\u00ed, scr\u00edobhtar an t-athr\u00fa ar dt\u00fas chuig an log\u00e1il idirbhirt sa chuimhne, ansin sruthla\u00edtear chuig an gcomhad log\u00e1la fisici\u00fail ar an diosca \u00e9 sula nd\u00e9antar na leathanaigh sonra\u00ed iarbh\u00edr a nuashonr\u00fa sna comhaid bhunachar sonra\u00ed (MDF\/NDF). R\u00e1tha\u00edonn s\u00e9 seo comhl\u00edonadh ACID (Adamhacht, Comhsheasmhacht, Leithlisi\u00fa, Marthanacht), ag cinnti\u00fa, i gc\u00e1s timpiste, gur f\u00e9idir le SQL Server idirbhearta a athsheinm (rolladh ar aghaidh) n\u00f3 a cheal\u00fa (rolladh siar).<\/p>\n

Comhaid Log\u00e1la F\u00edor\u00fala (VLFanna) agus Log\u00e1il Chiorclach<\/h3>\n

Go hinmhe\u00e1nach, roinntear an comhad log\u00e1la idirbhirt fisici\u00fail (LDF) ina dheighleoga n\u00edos l\u00fa, loighci\u00fala ar a dtugtar Comhaid Log\u00e1la F\u00edor\u00fala (VLFanna). Oibr\u00edonn an log\u00e1il idirbhirt go ciorclach. De r\u00e9ir mar a scr\u00edobhtar taifid log\u00e1la, l\u00edonann siad VLF amh\u00e1in agus bogann siad go dt\u00ed an ch\u00e9ad cheann eile.<\/p>\n

Nuair a shroicheann an log\u00e1il deireadh an chomhaid fhisici\u00fail, d\u00e9anann s\u00e9 iarracht filleadh ar an t\u00fas. Mar sin f\u00e9in, n\u00ed f\u00e9idir leis VLF a fhorscr\u00edobh ach amh\u00e1in m\u00e1 t\u00e1 an VLF sin marc\u00e1ilte mar neamhghn\u00edomhach<\/strong>. M\u00e1 t\u00e1 gach VLF gn\u00edomhach (rud a chialla\u00edonn go bhfuil taifid log\u00e1la iontu at\u00e1 f\u00f3s ag teast\u00e1il \u00f3 SQL Server), n\u00ed f\u00e9idir leis an log\u00e1il filleadh. M\u00e1 t\u00e1 f\u00e1s uathoibr\u00edoch cumasaithe agus sp\u00e1s diosca ar f\u00e1il, f\u00e1sann an comhad fisici\u00fail. M\u00e1 t\u00e1 an diosca l\u00e1n n\u00f3 m\u00e1 t\u00e1 srian ar fh\u00e1s uathoibr\u00edoch, tiocfaidh t\u00fa ar Earr\u00e1id 9002.<\/p>\n

Trunc\u00fa Log\u00e1la vs. Laghd\u00fa Log\u00e1la<\/h3>\n

Is m\u00edthuiscint choitianta \u00e9 go laghda\u00edonn trunc\u00fa na log\u00e1la m\u00e9id an chomhaid fhisici\u00fail.
\n* Trunc\u00fa Log\u00e1la:<\/strong> An pr\u00f3iseas chun VLFanna gn\u00edomhacha a mharc\u00e1il mar neamhghn\u00edomhach, rud a fh\u00e1gann go bhfuil an sp\u00e1s ar f\u00e1il le hath\u00fas\u00e1id. N\u00ed<\/em> laghda\u00edonn s\u00e9 seo m\u00e9id an chomhaid LDF ar an diosca.
\n* Laghd\u00fa Log\u00e1la:<\/strong> An pr\u00f3iseas chun m\u00e9id an chomhaid LDF a laghd\u00fa go fisici\u00fail agus sp\u00e1s a thabhairt ar ais don ch\u00f3ras oibri\u00fach\u00e1in.<\/p>\n

Sa tsamhail T\u00e9arnaimh Ioml\u00e1n, n\u00ed<\/em> tharla\u00edonn trunc\u00fa log\u00e1la ach amh\u00e1in nuair a chr\u00edochna\u00edtear c\u00faltaca log\u00e1la idirbhirt go rath\u00fail (ag glacadh leis nach bhfuil aon phr\u00f3isis eile ag coinne\u00e1il na log\u00e1la gn\u00edomhach).<\/p>\n

Diagn\u00f3is ar an Earr\u00e1id “Log\u00e1il Idirbhirt L\u00e1n” (Earr\u00e1id 9002)<\/h2>\n

Nuair a bh\u00edonn an log\u00e1il l\u00e1n, n\u00ed h\u00e9 do ch\u00e9ad ch\u00e9im sp\u00e1s diosca a chur leis go dall n\u00f3 comhaid a laghd\u00fa. N\u00ed m\u00f3r duit a aithint c\u00e9n f\u00e1th<\/em> nach f\u00e9idir leis an log\u00e1il trunc\u00fa. Sol\u00e1thra\u00edonn SQL Server meicn\u00edocht ionsuite chun a insint duit go d\u00edreach cad at\u00e1 ag cosc ath\u00fas\u00e1id log\u00e1la tr\u00edd an amharc catal\u00f3ige sys.databases<\/code>.<\/p>\n

Rith an t-ord\u00fa T-SQL seo a leanas chun an bac a aithint:<\/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
Is f\u00e9idir leat \u00fas\u00e1id sp\u00e1is reatha do log\u00e1lacha idirbhirt a sheice\u00e1il freisin ag baint \u00fas\u00e1ide as:<\/p>\n
DBCC SQLPERF(LOGSPACE);\n<\/code><\/pre>\n
St\u00e1it choitianta log_reuse_wait_desc<\/code><\/h3>\n
    \n
  1. LOG_BACKUP:<\/strong> T\u00e1 an bunachar sonra\u00ed sa tsamhail t\u00e9arnaimh Ioml\u00e1n n\u00f3 Bulk-Logged, agus n\u00edor t\u00f3gadh c\u00faltaca log\u00e1la idirbhirt le d\u00e9ana\u00ed. Is \u00e9 seo an ch\u00fais is coitianta.<\/li>\n
  2. ACTIVE_TRANSACTION:<\/strong> T\u00e1 idirbheart fada (m.sh., athth\u00f3g\u00e1il inn\u00e9acs ollmh\u00f3r n\u00f3 idirbheart neamhthiomanta dearmadta) ag coinne\u00e1il na log\u00e1la gn\u00edomhach.<\/li>\n
  3. REPLICATION \/ CDC:<\/strong> T\u00e1 At\u00e1irgeadh Idirbheartach n\u00f3 Gabh\u00e1il Sonra\u00ed Athraithe (CDC) cumasaithe, agus n\u00edor phr\u00f3ise\u00e1il an Gn\u00edomhaire L\u00e9itheoir Log\u00e1la na hidirbhearta f\u00f3s.<\/li>\n
  4. AVAILABILITY_REPLICA:<\/strong> I nGr\u00fapa Infhaighteachta AlwaysOn, t\u00e1 macasamhail t\u00e1naisteach d\u00edcheangailte n\u00f3 ag sioncr\u00f3n\u00fa r\u00f3-mhall, rud a chuireann iallach ar an bpr\u00edomh-mhacasamhail taifid log\u00e1la a choinne\u00e1il go dt\u00ed go nd\u00e9antar iad a chruas\u00fa ar an macasamhail t\u00e1naisteach.<\/li>\n<\/ol>\n
    Strait\u00e9is\u00ed T\u00e9arnaimh Tapa: An Fhadhb a R\u00e9iteach i T\u00e1irgeadh<\/h2>\n
    Ag brath ar an log_reuse_wait_desc<\/code> a fhaightear, athr\u00f3idh do fhreagairt \u00e9igeand\u00e1la. Seo iad na strait\u00e9is\u00ed t\u00e9arnaimh tapa do na c\u00e1sanna is coitianta.<\/p>\n
    C\u00e1s 1: C\u00faltaca\u00ed Log\u00e1la ar Iarraidh n\u00f3 ag Teip (LOG_BACKUP<\/code>)<\/h3>\n
    M\u00e1 t\u00e1 an cine\u00e1l feithimh LOG_BACKUP<\/code>, t\u00e1 an r\u00e9iteach simpl\u00ed: n\u00ed m\u00f3r duit c\u00faltaca a dh\u00e9anamh den log\u00e1il idirbhirt.<\/p>\n
    BACKUP LOG [YourDatabaseName] \nTO DISK = 'N:BackupsYourDatabaseName_EmergencyLog.trn' \nWITH COMPRESSION, STATS = 10;\n<\/code><\/pre>\n
    Nuair a chr\u00edochna\u00edonn an c\u00faltaca, d\u00e9anfar na VLFanna neamhghn\u00edomhacha a trunc\u00fa, agus atos\u00f3idh SQL Server gn\u00e1thoibr\u00edochta\u00ed. M\u00e1 t\u00e1 do thiom\u00e1int c\u00faltaca l\u00e1n, b’fh\u00e9idir go mbeidh ort c\u00faltaca a dh\u00e9anamh chuig sciar l\u00edonra sealadach n\u00f3 gl\u00e9as null (n\u00ed mholtar go l\u00e1idir \u00e9 mura bhfuil an bunachar sonra\u00ed in-at\u00e1irgthe go h\u00e9asca, mar go mbriseann s\u00e9 an slabhra log\u00e1la):<\/p>\n
    -- RABHADH: Briseann s\u00e9 seo an slabhra log\u00e1la agus cuireann s\u00e9 isteach ar th\u00e9arnamh pointe-in-am.\n-- N\u00e1 h\u00fas\u00e1id ach amh\u00e1in m\u00e1 t\u00e1 s\u00e9 f\u00edor-riachtanach agus lean l\u00e1ithreach le c\u00faltaca IOML\u00c1N.\nBACKUP LOG [YourDatabaseName] TO DISK = 'NUL';\n<\/code><\/pre>\n
    C\u00e1s 2: Idirbhearta Gn\u00edomhacha Fada (ACTIVE_TRANSACTION<\/code>)<\/h3>\n
    M\u00e1 t\u00e1 idirbheart amh\u00e1in ag rith le huaireanta, cuireann s\u00e9 cosc ar thrunc\u00fa log\u00e1la ar feadh na tr\u00e9imhse ar fad. Ar dt\u00fas, aithin an t-idirbheart ciontach:<\/p>\n
    DBCC OPENTRAN('YourDatabaseName');\n<\/code><\/pre>\n
    Tugann an t-ord\u00fa seo an t-idirbheart gn\u00edomhach is sine agus a Aitheantas Pr\u00f3isis Freastala\u00ed (SPID) ar ais. Is f\u00e9idir leat tuilleadh sonra\u00ed a bhaili\u00fa faoin m\u00e9id at\u00e1 an SPID ag d\u00e9anamh tr\u00ed cheist a chur ar amhairc bhainist\u00edochta dinimici\u00fala (DMVanna):<\/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
    M\u00e1s ceist chalaoiseach n\u00f3 pr\u00f3iseas at\u00e1 i bhfost\u00fa \u00e9 an t-idirbheart, b’fh\u00e9idir go mbeidh ort \u00e9 a fhoirceannadh chun an log\u00e1il a shaoradh.<\/p>\n
    KILL <SPID>;\n<\/code><\/pre>\n
    N\u00f3ta: M\u00e1 mhara\u00edtear idirbheart ollmh\u00f3r spreagfar rolladh siar, rud a d’fh\u00e9adfadh m\u00e9id suntasach ama a th\u00f3g\u00e1il agus ginfidh s\u00e9 gn\u00edomha\u00edocht log\u00e1la bhreise go sealadach. N\u00e1 atos\u00fa seirbh\u00eds SQL Server le linn rolladh siar, n\u00f3 rachaidh an bunachar sonra\u00ed isteach i m\u00f3d t\u00e9arnaimh nuair a atos\u00f3far \u00e9.<\/em><\/p>\n
    C\u00e1s 3: Leithdh\u00e1ileadh Sp\u00e1is \u00c9igeand\u00e1la (Diosca 100% L\u00e1n)<\/h3>\n
    M\u00e1 t\u00e1 an comhad LDF tar \u00e9is an tiom\u00e1int ar fad a ithe, n\u00ed f\u00e9idir leat fi\u00fa c\u00faltaca a rith mar go dteasta\u00edonn m\u00e9id beag sp\u00e1is log\u00e1la \u00f3 SQL Server chun an t-imeacht c\u00faltaca f\u00e9in a thaifeadadh. Sa ch\u00e1s seo, n\u00ed m\u00f3r duit comhad log\u00e1la t\u00e1naisteach a chur le tiom\u00e1int eile a bhfuil sp\u00e1s ar f\u00e1il ann.<\/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
    Sol\u00e1thra\u00edonn s\u00e9 seo sp\u00e1s an\u00e1laithe do SQL Server l\u00e1ithreach. Nuair a bh\u00edonn an bunachar sonra\u00ed ar l\u00edne, t\u00f3g c\u00faltaca log\u00e1la idirbhirt, folmhaigh an comhad log\u00e1la t\u00e1naisteach, agus bain \u00e9:<\/p>\n
    -- 1. T\u00f3g c\u00faltaca log\u00e1la chun an log\u00e1il a trunc\u00fa\nBACKUP LOG [YourDatabaseName] TO DISK = '...';\n\n-- 2. Folmhaigh an comhad log\u00e1la sealadach\nDBCC SHRINKFILE (N'YourDatabaseName_Log2', EMPTYFILE);\n\n-- 3. Bain an comhad log\u00e1la sealadach\nALTER DATABASE [YourDatabaseName] REMOVE FILE [YourDatabaseName_Log2];\n<\/code><\/pre>\n
    Dea-Chleachtais maidir le Cosc agus Bainist\u00edocht Log\u00e1la Idirbhirt<\/h2>\n
    T\u00e1 fabhtcheart\u00fa imoibr\u00edoch strusmhar agus b\u00edonn tionchar aige ar SLAanna. T\u00e1 cur i bhfeidhm dea-chleachtais ailtireachta agus oibr\u00edocht\u00fala r\u00e9amhghn\u00edomhacha riachtanach do chobhsa\u00edocht bunachar sonra\u00ed fiontair.<\/p>\n
    1. Cuir Strait\u00e9is C\u00faltaca Uathoibrithe L\u00e1idir i bhFeidhm<\/h3>\n
    M\u00e1 t\u00e1 bunachar sonra\u00ed sa tsamhail t\u00e9arnaimh Ioml\u00e1n, t\u00e1 c\u00faltaca\u00ed log\u00e1la idirbhirt go minic \u00e9igeantach. Ag brath ar do Chusp\u00f3ir Pointe T\u00e9arnaimh (RPO) agus toirt idirbhirt, ba cheart c\u00faltaca\u00ed log\u00e1la a tharl\u00fa gach 5 go 15 n\u00f3im\u00e9ad.<\/p>\n
    D\u00e9anann r\u00e9itigh ch\u00faltaca fiontair cos\u00fail le CloudSave an pr\u00f3iseas seo a shimpli\u00fa go suntasach. Tr\u00ed chomhth\u00e1th\u00fa go d\u00edreach le SQL Server tr\u00ed VDI (Comh\u00e9adan Gl\u00e9as F\u00edor\u00fail), ligeann CloudSave do DBAanna c\u00faltaca\u00ed log\u00e1la idirbhirt ard-minic\u00edochta at\u00e1 bunaithe ar bheartas a chumr\u00fa. Cinnt\u00edonn s\u00e9 seo go nd\u00e9antar log\u00e1lacha a trunc\u00fa go lean\u00fanach, a chripti\u00fa go sl\u00e1n, agus a st\u00f3r\u00e1il lasmuigh den l\u00e1thair n\u00f3 i st\u00f3r\u00e1il scamall do-athraithe, rud a choscann staid feithimh LOG_BACKUP<\/code> gan g\u00e1 le poist chasta saincheaptha SQL Agent.<\/p>\n
    2. M\u00e9id Ceart na Log\u00e1la Idirbhirt agus Bainistigh VLFanna<\/h3>\n
    Is frith-phatr\u00fan cont\u00fairteach \u00e9 brath ar fh\u00e1s uathoibr\u00edoch chun m\u00e9id do log\u00e1la idirbhirt a bhainisti\u00fa. T\u00e1 oibr\u00edochta\u00ed f\u00e1is uathoibr\u00edoch costasach agus cuireann siad pr\u00f3ise\u00e1il idirbhirt ar sos agus an diosca \u00e1 th\u00fas\u00fa go nialas (mura bhfuil T\u00fas\u00fa Comhad Meandarach cumasaithe, rud nach mbaineann le comhaid log\u00e1la).<\/p>\n
    Thairis sin, b\u00edonn ilroinnt VLF<\/strong> mar thoradh ar fh\u00e1sanna uathoibr\u00edocha beaga go minic (m.sh., ag f\u00e1s 10% n\u00f3 50MB ag an am). D\u00e9anfaidh log\u00e1il idirbhirt le m\u00edlte VLF b\u00eddeacha amanna tosaithe bunachar sonra\u00ed, feidhm\u00edocht ch\u00faltaca, agus latency at\u00e1irgthe a dh\u00edghr\u00e1d\u00fa go m\u00f3r.<\/p>\n
      \n
    • R\u00e9amh-mh\u00e9id na log\u00e1la:<\/strong> D\u00e9an anail\u00eds ar do chuid oibr\u00edochta\u00ed cothabh\u00e1la is m\u00f3 (cos\u00fail le hathth\u00f3g\u00e1il inn\u00e9acs) agus r\u00e9amh-mh\u00e9id an chomhaid LDF chun freastal orthu gan f\u00e1s.<\/li>\n
    • Socraigh f\u00e1s uathoibr\u00edoch seasta:<\/strong> Athraigh f\u00e1s uathoibr\u00edoch \u00f3 ch\u00e9atad\u00e1n go m\u00e9id seasta (m.sh., 1GB n\u00f3 5GB) chun a chinnti\u00fa go gcrutha\u00edtear VLFanna ag m\u00e9id sl\u00e1inti\u00fail.<\/li>\n<\/ul>\n
      Is f\u00e9idir leat do l\u00edon VLF a sheice\u00e1il ag baint \u00fas\u00e1ide as an gceist seo a leanas (do 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
      M\u00e1 t\u00e1 do l\u00edon VLF os cionn 500, smaoinigh ar fanacht ar thr\u00e9imhse chi\u00fain, an log\u00e1il a laghd\u00fa go m\u00e9id \u00edosta, agus \u00e9 a fh\u00e1s de l\u00e1imh ar ais go dt\u00ed an m\u00e9id riachtanach i gcodanna m\u00f3ra.<\/p>\n
      3. Optamaigh Oibr\u00edochta\u00ed Cothabh\u00e1la Inn\u00e9acs<\/h3>\n
      Is oibr\u00edochta\u00ed log\u00e1ilte go hioml\u00e1n iad athth\u00f3g\u00e1il inn\u00e9acs, fi\u00fa sa tsamhail t\u00e9arnaimh Bulk-Logged (ag brath ar an gcine\u00e1l inn\u00e9acs). Gineann athth\u00f3g\u00e1il inn\u00e9acs 500GB ar a laghad 500GB de thaifid log\u00e1la idirbhirt.<\/p>\n
      Chun bloat log\u00e1la a mhaol\u00fa le linn cothabh\u00e1la:
      \n*   \u00das\u00e1id SORT_IN_TEMPDB = ON<\/code> agus inn\u00e9acsanna \u00e1 n-athth\u00f3g\u00e1il. D\u00edluchta\u00edonn s\u00e9 seo an ch\u00e9im s\u00f3rt\u00e1la chuig TempDB, ag laghd\u00fa an ualaigh ar log\u00e1il idirbhirt an bhunachar sonra\u00ed \u00fas\u00e1ideora.
      \n*   Athraigh \u00f3 athth\u00f3g\u00e1il<\/em> inn\u00e9acs go reorganize<\/em> inn\u00e9acs nuair is f\u00e9idir, mar go bhfuil reorganizations n\u00edos \u00e9ifeachta\u00ed \u00f3 thaobh log\u00e1la agus is f\u00e9idir iad a chur isteach gan an oibr\u00edocht ar fad a rolladh siar.
      \n*   Baisc oibr\u00edochta\u00ed m\u00f3ra DELETE<\/code> n\u00f3 UPDATE<\/code>. In ionad 10 milli\u00fan r\u00f3 a scriosadh in aon idirbheart amh\u00e1in, scrios iad i mbaisceanna de 50,000, ag tiomn\u00fa agus ag ligean do ch\u00faltaca\u00ed log\u00e1la an log\u00e1il a trunc\u00fa idir baisceanna.<\/p>\n
      4. Monat\u00f3ireacht a dh\u00e9anamh ar Ard-Infhaighteacht agus Topola\u00edochta\u00ed At\u00e1irgthe<\/h3>\n
      I nGr\u00fapa\u00ed Infhaighteachta AlwaysOn, n\u00ed f\u00e9idir leis an bpr\u00edomh-mhacasamhail a log\u00e1il a trunc\u00fa go dt\u00ed go nd\u00e9antar na taifid log\u00e1la a chruas\u00fa ar gach macasamhail t\u00e1naisteach sioncr\u00f3nach agus asincr\u00f3nach.<\/p>\n
      M\u00e1 th\u00e9ann macasamhail t\u00e1naisteach as l\u00edne, n\u00f3 mura f\u00e9idir leis an bandaleithead l\u00edonra coinne\u00e1il suas le r\u00e1ta gini\u00fana idirbhirt an phr\u00edomh-mhacasamhail, f\u00e1sfaidh scuaine seolta an phr\u00edomh-mhacasamhail, agus l\u00edonfar an log\u00e1il (cine\u00e1l feithimh AVAILABILITY_REPLICA<\/code>).<\/p>\n
      Cuir monat\u00f3ireacht l\u00e1idir i bhfeidhm don chuntar feidhm\u00edochta SQLServer:Replica > Log Send Queue<\/code>. M\u00e1 chailltear macasamhail t\u00e1naisteach go buan, n\u00ed m\u00f3r duit \u00e9 a bhaint as an nGr\u00fapa Infhaighteachta n\u00f3 gluaiseacht sonra\u00ed a chur ar fionra\u00ed chun ligean don phr\u00edomh-log\u00e1il trunc\u00fa.<\/p>\n
      Concl\u00faid<\/h2>\n
      Is rite pas\u00e1iste \u00e9 log\u00e1il idirbhirt l\u00e1n a fh\u00e1il do riarth\u00f3ir\u00ed bunachar sonra\u00ed, ach n\u00ed g\u00e1 go mbeadh aga neamhfh\u00f3naimh fada mar thoradh air. Tr\u00ed thuiscint a fh\u00e1il ar mheicnic na Log\u00e1la R\u00e9amh-Scr\u00edofa agus VLFanna, is f\u00e9idir leat an bhunch\u00fais a dhiagn\u00f3isi\u00fa go tapa ag baint \u00fas\u00e1ide as sys.databases<\/code> agus an strait\u00e9is t\u00e9arnaimh tapa cheart a chur i bhfeidhm.<\/p>\n
      Braitheann cobhsa\u00edocht fhadt\u00e9armach ar bhogadh ar shi\u00fal \u00f3 shocruithe imoibr\u00edocha. Tr\u00ed do chomhaid log\u00e1la a r\u00e9amh-mh\u00e9id, gn\u00e1thaimh chothabh\u00e1la a optam\u00fa, agus ard\u00e1in ch\u00faltaca de ghr\u00e1d fiontair cos\u00fail le CloudSave a \u00fas\u00e1id chun sceidil ch\u00faltaca log\u00e1la daingean, uathoibrithe a fhorfheidhmi\u00fa, cinnteoidh t\u00fa go bhfanfaidh do log\u00e1lacha idirbhirt sl\u00e1inti\u00fail, truncaithe, agus r\u00e9idh chun tac\u00fa le huala\u00ed oibre t\u00e1irgthe ard-tr\u00e9chur.<\/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":[495],"tags":[990,4082,4083,4084,4085,4086,4087],"class_list":["post-5904","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\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Log Idirbhirt MSSQL L\u00e1n: Strait\u00e9is\u00ed um Chosc agus Aisghabh\u00e1il Thapa\" \/>\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\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/\" \/>\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:52:18+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=\"13 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\\\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\\\/\"},\"author\":{\"name\":\"shervinrv\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\"},\"headline\":\"Log Idirbhirt MSSQL L\u00e1n: Strait\u00e9is\u00ed um Chosc agus Aisghabh\u00e1il Thapa\",\"datePublished\":\"2026-06-16T16:15:28+00:00\",\"dateModified\":\"2026-06-16T16:52:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\\\/\"},\"wordCount\":2306,\"publisher\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\"},\"keywords\":[\"Database Administration\",\"Error 9002\",\"Log Backup\",\"MSSQL\",\"SQL Recovery\",\"SQL Server\",\"Transaction Log\"],\"articleSection\":[\"Database Backup\"],\"inLanguage\":\"ga\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\\\/\",\"url\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\\\/\",\"name\":\"MSSQL Transaction Log Full: Prevention & Recovery\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/#website\"},\"datePublished\":\"2026-06-16T16:15:28+00:00\",\"dateModified\":\"2026-06-16T16:52:18+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\\\/ga\\\/knowledge-base\\\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\\\/#breadcrumb\"},\"inLanguage\":\"ga\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/knowledge-base\\\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cloudsave.app\\\/ga\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Log Idirbhirt MSSQL L\u00e1n: Strait\u00e9is\u00ed um Chosc agus Aisghabh\u00e1il Thapa\"}]},{\"@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":"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\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/","og_locale":"en_US","og_type":"article","og_title":"Log Idirbhirt MSSQL L\u00e1n: Strait\u00e9is\u00ed um Chosc agus Aisghabh\u00e1il Thapa","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\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/","og_site_name":"CloudSave","article_published_time":"2026-06-16T16:15:28+00:00","article_modified_time":"2026-06-16T16:52:18+00:00","author":"shervinrv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"shervinrv","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cloudsave.app\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/#article","isPartOf":{"@id":"https:\/\/cloudsave.app\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/"},"author":{"name":"shervinrv","@id":"https:\/\/cloudsave.app\/ga\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d"},"headline":"Log Idirbhirt MSSQL L\u00e1n: Strait\u00e9is\u00ed um Chosc agus Aisghabh\u00e1il Thapa","datePublished":"2026-06-16T16:15:28+00:00","dateModified":"2026-06-16T16:52:18+00:00","mainEntityOfPage":{"@id":"https:\/\/cloudsave.app\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/"},"wordCount":2306,"publisher":{"@id":"https:\/\/cloudsave.app\/ga\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d"},"keywords":["Database Administration","Error 9002","Log Backup","MSSQL","SQL Recovery","SQL Server","Transaction Log"],"articleSection":["Database Backup"],"inLanguage":"ga"},{"@type":"WebPage","@id":"https:\/\/cloudsave.app\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/","url":"https:\/\/cloudsave.app\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/","name":"MSSQL Transaction Log Full: Prevention & Recovery","isPartOf":{"@id":"https:\/\/cloudsave.app\/ga\/#website"},"datePublished":"2026-06-16T16:15:28+00:00","dateModified":"2026-06-16T16:52:18+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\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/#breadcrumb"},"inLanguage":"ga","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudsave.app\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cloudsave.app\/ga\/knowledge-base\/log-idirbhirt-mssql-l%c3%a1n-strait%c3%a9is%c3%ad-um-chosc-agus-aisghabh%c3%a1il-thapa\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudsave.app\/ga\/"},{"@type":"ListItem","position":2,"name":"Log Idirbhirt MSSQL L\u00e1n: Strait\u00e9is\u00ed um Chosc agus Aisghabh\u00e1il Thapa"}]},{"@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\/5904","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=5904"}],"version-history":[{"count":1,"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/posts\/5904\/revisions"}],"predecessor-version":[{"id":5969,"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/posts\/5904\/revisions\/5969"}],"wp:attachment":[{"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/media?parent=5904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/categories?post=5904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudsave.app\/ga\/wp-json\/wp\/v2\/tags?post=5904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}