Ellie's blog

Replication, change tracking, change data capture & availability groups - SQL Server Always On | Microsoft Learn
enable 1448 globally

heap/clustered index / nonclustered index 

訂閱端誤刪table，重新initialize 單一table 

Msg 22004, Level 16, State 1, Line 0
Failed to open loopback connection. Please see event log for more information.
Msg 22004, Level 16, State 1, Line 0
Error log location not found.
 

Mail stuck in ExternalMailQueue 

This login ([NT SERVICE\MSSQLSERVER ) is needed, no matter DB mail was configured under which service account. 

若要自動建立 CNO，建立容錯移轉叢集的使用者必須擁有組織單位 (OU) 或是將構成叢集的伺服器所在容器的 Create Computer objects/建立電腦物件 權限。

fn_dblog & fn_dump_dblog

Synonyms (Database Engine) - SQL Server | Microsoft Learn

SQL 重啟時會以sys.master_files記錄的size重建TempDB

• tempdb.sys.database_files : 記錄目前size
• sys.master_files : 記錄configured size / SQL重啟時會以configure size建立Temp DB

physical and logical IO activity

AG + TDE

DB Mirror without join domain

Linked Server  連到 AG readonly node 

若replica是在Replication設定後才加入AG，那麼該replica可能無法即時看見Local Publications。若該replica開放readable 或是當AG failover到該replica時，便可看見。

AG + Read-only Routing

DBCC checkdb / dbcc checktable

SqlLocalDB / multiple versions

SetSPN

SQL error code 列表

Database '%.*ls' cannot be opened. It is in the middle of a restore