Hi. We have an issue where there is sometimes an interruption to our database server. We think that it is when our hoster does the backups.

Is there a way that File Sight Ultra can attempt to reconnect every few minutes until it can again. Many thanks Dave

asked 12 Jun '18, 03:35

Marcwolf's gravatar image

Marcwolf
1023
accept rate: 0%


Hi Dave

It should already be doing that. And while the connection is failing, anything that would have been written to the SQL Server database will be dumped to a local database file, which will then be sent to the real database once the connection has been reestablished.

If this isn't what you are experiencing, please contact Customer Support (email to support@poweradmin.com). I'm sure we'll ask to see the service log to see what issues are happening with the database.

Doug

link

answered 12 Jun '18, 19:50

Doug's gravatar image

Doug ♦♦
10.2k122138
accept rate: 21%

Many thanks for that information.

We use you system on the file server of a large industrial plant. When a machine on the production line requests a file.. as each machine is a valid user, we can track the progress of a job through the factory by it's 'READ's We have modified the FileSightFinding table with an extra field called 'Processed' so we can mark that when we have read the event. To stop the table getting too large we delete all processed records periodically.

Just so you know how we use your product. If you want a Case Study I'll be happy to write one.

Take Care Dave

link

answered 12 Jun '18, 20:50

Marcwolf's gravatar image

Marcwolf
1023
accept rate: 0%

That is a really cool and unique use of the product! We'd love to have a case study!

(13 Jun '18, 09:47) Doug ♦♦
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

Tags:

×23
×22
×19
×4
×4

Asked: 12 Jun '18, 03:35

Seen: 3,358 times

Last updated: 13 Jun '18, 09:47