Saturday, August 25, 2012

Recommended SQL Server files to be in anti-virus exclusions

Below SQL Server related files can be included in exclusion list of Anti-Virus, because the files may locked while scanning or sometimes anti-virus may prevent accessing them or we may face performance degradation while accessing them.

.Mdf -- SQL Server Primary Data File
.Ldf  -- SQL Server Transaction Log File
.Trn  -- Transaction Log Backup
.Bak -- Full Backup
.Diff  -- Differential Backup
.Ndf  -- SQL Server Secondar Data File
.Sql   -- SQL Script Files

No comments: