Maintenance on SQL Server hosting App volumes

[nevgeo01]

Hi All,

We have maintenance schedule for our SQL server hosting App volumes database. Its going to be a restart process, I would like to know if there is any steps need to be followed on the App volumes end.

Also would like to know if there is any disconnection for users as we have App volumes mapped to RDS hosts.

Below is the environment

Horizon 7

App volumes 2.12

UEM 9.1

SQL Server 2014 SP1 Standard

RDS Hosts with App Stacks

Please Advice.

[howde]

Best bet would be to look into setting up (or having DBAs set up) SQL AlwaysOn with another SQL instance. It is a very straight forward configuration. This would prevent the DB from ever truly going offline during routine maintenance operations. Feel free to DM if you would like some good links that detail how to set that up.

As for existing appstacks mapped. If the appstacks are already mounted, taking the DB server offline will not strip this appstack away from the host that has it currently mapped. There is definitely a possibility that you will need to cycle the appvolumes AVM once the DB is back online but I can't say for certain what else might be needed.

[sjesse]

As for the proper method, I think the always on cluster that was mentioned it probably best, but I auto patch our SQL server and I've never had any problems.I'd do these at the time of the lowest possible use, if the sql server isn't available, appstacks won't attach.

[Ray_handels]

We just reboot our SQL server every month due to MS patches.

The database is only used when a user logs in, it then checks which applications are needed and delivers them to you. No Database, no applications when logging in.

Users that are logged in already have appstacks attached and nothing will happen there...