sql agent ever restart sql?

jasenf · December 6, 2010 10:14PM

I have to install RedGate's SQLAgent on a production machine that can not have any downtime unless it is scheduled. Does installation of SqlAgent ever cause SQLServer to be restarted? or server reboots?

thanks,
jasen

petey · December 6, 2010 10:46PM

By RedGate's SQLAgent, I assume you are referring to the SQL Backup Agent service.

No, you never need to restart the SQL Server service, nor reboot Windows, when you install the SQL Backup Agent. Neither do you need to restart SQL Server nor reboot Windows during an upgrade of the SQL Backup Agent service.

However, you may need to restart the SQL Server service when upgrading the SQL Backup extended stored procedure library. This happens when the SQL Server process does not release the library correctly, thus locking the file and preventing it from being overwritten. This is a common occurrence if you are running SQL Server 2000, and is rare on SQL Server 2005 or 2008.

Note that so far, then has been minimal changes to the stored procedure library for the same major version releases e.g. 6.0, 6.1, 6.2, 6.3. All or most of the changes are in the SQL Backup Agent and also the GUI.

jasenf · December 6, 2010 10:50PM

Thanks for the quick reply!! Is there anyway to know if SQL has a lock on these extended sp.'s??

petey · December 6, 2010 11:07PM

Is there anyway to know if SQL has a lock on these extended sp.'s??

To really know, try to replace the extended stored procedure library file (xp_sqlbackup.dll) in the SQL Server Binn folder, after running DBCC xp_sqlbackup(FREE).

sql agent ever restart sql?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk