Full backup fails

• 
  Jamie,
  
  What version of SQLBackup are you running?
  
  if it is 6.0 or above I believe that the GUI will have a show log entry for each job that tries to run. If the messages don't show enough then the error number can be looked up on this site or in the help contents of the GUI.
  
  HTH
  
  Chris

  ChrisAVWood August 08, 2011 12:30

  - 0 +
• 
  Please post the contents of the SQL Backup log for the failed backup.
  
  The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.

  petey August 09, 2011 00:31

  - 0 +
• 
  A log file is not being created - it looks like the job isn't running as it should take 15 mins or so to back all the db's up.
  
  Thanks for your help so far and apologies for my delay getting back.
  
  
  J

  JamieA August 10, 2011 10:10

  - 0 +
• 
  Could you then please use SSMS to check on the SQL Server Agent logs for the job that was supposed to have ran the backups?
  
  Thanks.

  petey August 10, 2011 11:52

  - 0 +
• 
  I now see the problem, and it's a permissions issue. Thanks for pointing me in the right direction.
  
  J

  JamieA August 11, 2011 04:22

  - 0 +

Add comment

Please sign in to leave a comment.