We have a database with external users in a server that needs to be restarted due the instalation of another software.
I need to know which is the proper way to shutdown the server without causing any data loss to current transactions in progress.
I also need to know if the method recommened will wait all users to logout or not, or it will just wait to current transactions to finish/rollback on their own.
Also, it is needed to shut down also the SQL Server service ?
Thanks in advance,