Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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
959405069
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.8k171175
accept rate: 25%

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
9.0k130169257
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:

×84

question asked: 20 Oct '11, 10:10

question was seen: 2,243 times

last updated: 20 Oct '11, 11:00