Hi eliruda,

Yes i am sure i uploaded 4.1 to my server, try ctrl-F5 because you are probably seeing the cached version.

gr, t 🙂

Hi eliassal / elirueda,

I think i have found it, try downloading version 4.1 : http://www.ekelmans.com/FTP/Web/GoogleJobTimeline.sql

grtz, Theo

Hi Christian,

The site is running on a Intel NUC at my home, and has been up for about 2? years now, and i have no intention of taking it down,...

More options !!!

yay 🙂

VB6 - MS Access, wow.... 🙂

That was me (old fart here-- i'm 55), somewhere around 1998 - 2003, and for it's time VB6 was pretty powerfull, now.... not so much.

Access...

You could also use file share witness (read up on the pro's and con's)

I'd say 2 servers (vm or phy) per site where each site has it's own local AG...

Hi Dude,

SQL AG will buffer transactions when connections are lost and send them to the sites that are behind on a later time, so no worries there.

If every site has...

Well...

it's been close to 10 years ago that for an oil company i have setup a redundant central SQL server in NL (using mirroring), and merge replication of regional data...

Ah, good point Ed!

I forgot to mention 3 things:

1: The app is a fat client that resides on the workstations or laptop of each user, and the DB is on...

• This reply was modified 5 years, 7 months ago by  Theo Ekelmans.

Hi Dude,

You are looking at the wrong product for this, since there is no way you can have bi-directional HA using SQL server, readable secondaries is what the current state...

I sure hope you have SQL 2016 or higher and have the query store enabled for that DB.

If that is the case, you answer can be found there. The QS...

Well,

I's take a good look at the windows and SQL logs to see what happens just before the crash, and see if you can find a precursor to that error...

Hi William,. 

You might want to checkout the new version of this script: http://www.sqlservercentral.com/articles/Agent+jobs/127346/

It uses google graph and mail, so you can do away with the excel...

Hi Tim,
Several people mailed me about his, and i posted an updated version: http://www.ekelmans.com/FTP/Web/ImportSqlserverbuildsBlogspotCom.sql 

Thanks for the kind feedback all 🙂