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 

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

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

DB Mirror without join domain

Linked Server  連到 AG readonly node 

AG + Read-only Routing

SqlLocalDB / multiple versions

SetSPN

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

新增Disk至SQL FCI後， 若無法從SSMS看見新增的Disk，有可能是Resource漏了設定Dependencies

啟用或停用WSFC 節點的投票權

若AG裡的各replica位於不同subnet，建立SQL listener遇到Error 19456

Linked servers cannot be used under impersonation without a mapping for the impersonated login

錯誤碼為: 0x851A0044

Replication with DB Mirroring

摘要:Replication between 2008R2 and 2012