The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
959384969
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.6k114149237
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:

×71

question asked: 20 Oct '11, 10:10

question was seen: 836 times

last updated: 20 Oct '11, 11:00