The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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

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, or (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
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

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 20 Oct '11, 10:10

question was seen: 924 times

last updated: 20 Oct '11, 11:00