Products A-Z All Services Can't find what you're looking for? Chat Live!
Products A-Z Can't find what you're looking for? Chat Live!
Can't find what you're looking for? Chat Live!
SQL Server backups scheduled using the BMC stop after Microsoft updates are applied to server. In Dec 2009 we upgraded to SQL Server 2008 Standard from SQL Server 2000 Standard. No improvement of the scheduled backups after the SQL upgrade. OS is Microsoft Windows Server 2003 Enterprise. SQL backups successfully run after rescheduling thru BMC but cease to run the next night's backup after MS updates. I have reviewed BB118606 "Backup fails when scheduling a backup using the Blackbaud Management Console" but not applicable to our issue. Our ITS Department schedules the Microsoft Windows and Security updates; i.e. pushed out to servers on a schedule outside times SQL Server backups run. We are running RE 7.91.5056 and FE 7.80.94 on this server. If you have encounter this problem and may know of a cause and/or solution, your feedback appreciated.
Hi Fred,
This sounds like a very odd issue. This first thing I would check is that the SQL Server Agent service is set to automatic. This way if you have to reboot the server the services starts automatically. If it is set to manual this server may not be started when the Backup job is supposed to run.
If this is already selected, check the service to see if it is started after the MS Updates. They might be stopping that service for some reason.
Hope this helps!-David