Home > Storage > Data Storage Essentials > AppSync > Dell AppSync Integration with Microsoft SQL Server > Custom shutdown script before unmounts
Before an unmount, if you want to perform a customized shutdown of the database, you can place a script at the following location: %ProgramData%\EMC\AppSync\script\. The script name must be in this format:
<ServicePlanName>_<host_ProductionInstanceName OR ProductionInstanceName>_ShutdownSQL.bat
Where:
It is recommended to run the script as a Windows user. To run the script as a SQL Server user in an SQL Server environment, the Local System user must have the sysadmin role. The latter may vary depending on the versions that are implemented in that specific environment.
The same customized Shutdown script must be present on all the participant nodes of an SQL clustered instance in a clustered mount.
In the absence of a customized script, AppSync performs a shutdown of the databases before unmounting. It is not a configurable option in the UI, and AppSync looks for this script during the unmount operation. If the script is present and does not have proper access, or executable permissions, AppSync displays a warning and initiates the shutdown and unmount operation.