Question

Does Laserfiche 8.3.2 support SQL 2012 alwayson high availability?

Version 8

Updated September 4, 2018

asked on January 20, 2014

We are currently running Laserfiche 8.3.2 and the Laserfiche database is running on a SQL Server 2008 instance. We are looking at migrating Laserfiche DB to a SQL Server 2012 instance.

Is Laserfiche 8.3.2 compatible with SQL Server 2012 alwayson high availability groups? We would like to leverage this technology to easily failover from one SQL server to the next in case there is an issue.

http://technet.microsoft.com/en-us/library/ff877884.aspx

1 0

Answer

APPROVED ANSWER

replied on January 22, 2014

Laserfiche has not been tested with SQL Server AlwaysOn Availability Groups. If it does work, I suspect the performance will be poor though unless Laserfiche 9.1 or later is used because of the large number of transactional writes during folder browsing and search result listing.

1 0

replied on September 24, 2015 • Show version history

Hi Michael,

I'm having trouble with AGs on a customer site. Has there been any testing since this last reply? Are AGs still unsupported?

Also, do you how LFDS connects to the database server? Does it use ADO.net or OLEDB? Also, is it possible to edit the connection string?

Regards,

Ben

0 0

replied on January 4, 2016

We are also having trouble with our Availability Groups. Specifically, the Laserfiche Services must be restarted any time the AG experiences an internal failover. All other applications survive a failover in the AG with no special handling. Ben, is this the same thing your were seeing? Did you find a solution to your problem?

0 0

replied on September 4, 2018 • Show version history

Hi Michael, this still seems to be the case. AG works fine for business-as-usual but not during installation and upgrades.

Would you be able to confirm please?

-Ben

0 0

Replies

replied on January 23, 2014

Michael,

Thanks for the response. We will go down the path of upgrading our Laserfiche environment from 8.3.2 to 9.x and then re-evaluate and decide if we want to try implementing SQL alwayson.

0 0

You are not allowed to follow up in this post.

Question

Question

Does Laserfiche 8.3.2 support SQL 2012 alwayson high availability?

Answer

Replies

Sign in to reply to this post.