Need To Reliably Back Up Thousands of Databases Per Server

• 

  and we understand this to be a known issue with a number of backup tools.

  Do you know what was the cause of the issue?
  
  Thanks.

  petey June 27, 2011 20:59

  - 0 +
• 
  Not knowing the particular cause of the issues you're having, I'm using SQL Backup 6 on a SQL cluster which has 1100+ databases and growing, with no issues on the backup jobs.
  
  I did have an issue with the GUI console timing out when it was refreshing the activity window during the initial deployment of SQL Backup 6. That was resolved with a patch. It's still pretty slow refreshing, well, slower than I would like, but it won't time out now.
  
  With the backup jobs themselves, it's been smooth sailing so far.
  
  The only thing I would like is for Red Gate to add a parameter so that if a differential or log backup on xyz database is not possible because there's not a full backup yet, it automatically switches the backup for that database to a full.
  
  For the server I reference above, I use the 'USER DATABASES' parameter to backup everything, but if a new db is created in between fulls, I get annoying 'error' messages for the log or diff backups until I manually do a full backup of the offending database. Having SQL Backup handling this automatically via a parameter flag would be a plus.

  jhboricua June 28, 2011 12:15

  - 0 +
• 
  Well, scratch that. Ever since upgrading to 6.5.1.9 this particular server no longer populates the activity history window when I open my SQL Backup GUI console. It just sits there with a green spinning circle and on the SQL server, the process id that is being executed show incrementing wait of type MSQL_XP.
  
  So something is wrong. I have a ticket open with Red Gate but so far I'm not making progress.

  jhboricua July 27, 2011 10:48

  - 0 +

Add comment

Please sign in to leave a comment.