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

asked 20 Oct '11, 10:10

dejstone's gravatar image

dejstone
959395069
accept rate: 0%


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.

permanent link

answered 20 Oct '11, 10:20

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

edited 20 Oct '11, 10:34

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

(20 Oct '11, 11:00) Volker Barth

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

permanent link

answered 20 Oct '11, 10:25

Martin's gravatar image

Martin
8.6k116149237
accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×72

question asked: 20 Oct '11, 10:10

question was seen: 859 times

last updated: 20 Oct '11, 11:00