Sch Backup fails in cluster environment

• 
  Has SQL Backup been installed on both nodes? Please see http://www.red-gate.com/messageboard/viewtopic.php?t=1880 for details.

  petey January 10, 2007 02:27

  - 0 +
• 
  As far as I can tell SQL BAckup is installed on both nodes. I followed the instructions given to me from the Red-Gate salesperson for installing in the clustered environment. Those instructions were a reference to a forum post.

  mfaile January 10, 2007 09:54

  - 0 +
• 
  In that case, could you pls run a test backup on Server B, and provide us the resulting error message? Thanks.

  petey January 10, 2007 10:36

  - 0 +
• 
  The job failed. The Job was invoked by Schedule 120 (<Name Removed> Full Backup Schedule). The last step to run was step 1 (Step 1).
  
  This error is from the job history in EM. I assume that was the error message being referred to.

  mfaile January 10, 2007 10:41

  - 0 +
• 
  Could you pls run a backup job using Query Analyzer or Management Studio on Server B, and let us know the output? E.g.
  
  master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = [c:\model.sqb] WITH INIT"'
  
  Thanks.

  petey January 10, 2007 10:58

  - 0 +
• 
  QA message when SQL is running on Server B:
  
  "Trial has expired."
  
  Server A with same command runs the master backup fine.
  
  Matt

  mfaile January 10, 2007 19:58

  - 0 +
• 
  You need to activate the license on Server B. You can use the GUI for this. If Server B is not currently the active node, use the standalone ProductActivation application found in the SQL Backup folder.

  petey January 10, 2007 20:21

  - 0 +
• 
  Works fine now...thanks.

  mfaile January 10, 2007 21:31

  - 0 +

Add comment

Please sign in to leave a comment.