Does SQL Backup Install Require A Restart
EdCarden
Posts: 138 Silver 2
Does the installation of the server side components of SQL Backup Pro (what you have to install on each SQL Server that SQL Backup Pro will be backing up from/to) require a restart or reboot?
Does the answer to that change based on whether you are installing these via the SQL Backup GUI or if you are doing a manual install on the SQL Server?
Does the answer to that change based on whether you are installing these via the SQL Backup GUI or if you are doing a manual install on the SQL Server?
Comments
The SQL Backup server components consist of 3 parts - the Windows service agent, the extended stored procedures, and the command line interface. The service agent and command line interface are independent in nature (code wise) and does not have any dependencies that requires a Windows restart in order to install its components. The extended stored procedures are contained in a single DLL file that's installed in the SQL Server binn folder. You may sometimes need to restart the SQL Server service when upgrading because SQL Server cannot free the previous file, but that's fairly rare.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8