Scheduled Backup fails, no error

• 
  By default, the log files are generated in
  
  <system drive>\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>
  
  If the backup failed midway, you should see some files without a GUID value in its name (restores do not have a GUID value either).
  
  If you cannot find the relevant log files, I would suggest testing the backup command manually. I assume you are using the BACKUP DATABASES syntax? Copy the T-SQL script from your job step, and run it in Query Analyzer/SSMS, and see what errors turn up.

  petey August 14, 2006 21:04

  - 0 +
• 
  Pete,
  There are no logs, its seems that backup is not finishing, it just seems to stop after backing up model DB. I can do a manual backup of the DB's that are not getting backed up through the schedule. I will run the script through the Query Analyzer and see what happens. I am also going to delete all my scheduled backup jobs and recreate them.

  Bart430 August 15, 2006 09:26

  - 0 +
• 
  I figured out the problem, SQL Backup is hanging when trying to backup the msdb. A few strange things are that I never recieved an error message and no backup log was created by SQL Backup.
  Thanks,
  Bart

  Bart430 August 16, 2006 11:43

  - 0 +
• 
  What happens when you backup msdb directly e.g.
  
  master..sqlbackup '-sql "BACKUP DATABASE msdb TO DISK = [e:\temp\msdb.sqb] WITH INIT"'
  
  Thanks.

  petey August 16, 2006 12:49

  - 0 +
• 
  When I tried and do a manual backup, the program hangs at around 37%. The file is only about 32 mb and usually takes on a few seconds to backup. It does not give a error message or make an entry in the SQL backup log.
  
  I rebooted the server and can do a manaul backup now without the program hanging. I will run a normal scheduled backup tonight. I am running full backups by the way with lowest compression.

  Bart430 August 17, 2006 12:10

  - 0 +

Add comment

Please sign in to leave a comment.