should the sqla database folder be excluded from backups and virus scans?

[Former Member]

Hello, Should the sqla database folder be excluded from backups and virus scans? Should I recommend to my sqla customers that they exclude the live db folder from backup and virus detection processes? The database is being backed-up to another location and there are no executables in the database directory.

Thanks, Doug

[jeff_albion]

If the database is actively running, it is best practice not to have any other processes (virus-scanners, third-party backups, anti-spyware, etc.) attempt to touch the:

1. Database file
2. Transaction Log file
3. Temporary Folder (e.g. '%SATMP%\\sqla####.tmp')

This is particularly true if you run a database with the -m switch and are on a build before 9.0.2.3621, 10.0.1.3647 or 11.0.0.1133 (See: CR #489871) as this could result in failures to access the transaction log at run-time.

[VolkerBarth]

I would exclude viruses from these orders, as well:)

[MCMartin]

Also the backup file of your DB should be excluded from the anti-virus software.