Welcome to Forums Sign in | Join | Help | Forums
in Search


SQL Server scheduled backups stop after MS updates

Last post 03-03-2010 12:55 PM by David Johnson. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 02-08-2010 2:44 PM

    • Fred Gaines
    • Not Ranked
    • Posts 7
    • Organization: Kennesaw State University

    SQL Server scheduled backups stop after MS updates

    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.

  • 03-03-2010 12:55 PM In reply to

    Re: SQL Server scheduled backups stop after MS updates

     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.  

    1. Go to Start>Run and type services.msc 
    2. Find the service SQLServerAgent(InstanceName) (Where InstanceName is the name given to SQL Server.  If it is an unnamed instance it will be MSSQLSSERVER in the parentheses)
    3. Right Click and select properties.
    4. Make sure Startup type is set to Automatic.

    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

    Filed under: ,
Page 1 of 1 (2 items)