Full backup fails

Comments

• ChrisAVWood Posts: 361

  August 8, 2011 12:30PM

  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

  English DBA living in CANADA

  0 · Share on Twitter
• petey Redgate › Posts: 2,358 New member

  August 9, 2011 12:31AM

  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.

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• JamieA Posts: 12

  August 10, 2011 10:10AM

  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

  0 · Share on Twitter
• petey Redgate › Posts: 2,358 New member

  August 10, 2011 11:52AM

  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.

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• JamieA Posts: 12

  August 11, 2011 4:22AM

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

  0 · Share on Twitter