Clustering and Multiple Instances

• 
  Hello Richard,
  
  The complete answer is on the forums already:
  http://www.red-gate.com/messageboard/vi ... php?t=1880
  
  This should address any concerns you may have about SQL Backup on a cluster.

  Brian Donahue September 21, 2006 13:52

  - 0 +
• 
  Hi Brian,
  
  Thank you very much for your reply. The link provided has answered my questions.
  
  Cheers
  Rich

  richarde September 22, 2006 05:06

  - 0 +
• 
  I've looked at that post and it's not actually helped.
  
  I'm running the sqbserversetup -i clustername
  
  and sql backup still references the local machine for the backups. I still recieve error messages regarding the installation of the services. My database is called clientname-sql and resolves via DNS. I have the sql services running under a domain account (dba) and am installing sqlbackup as an administrator.
  
  Any assistance would be appreciated.
  
  Cheers,
  Gavin

  UKS-Gavin September 26, 2006 08:10

  - 0 +
• 
  What is your SQL Server virtual server name, and the instance name (if not the default instance)?

  petey September 26, 2006 12:40

  - 0 +
• 

  petey wrote:

  What is your SQL Server virtual server name, and the instance name (if not the default instance)?

  
  Hi Petey,
  
  Thanks for the quick response, the virtual server name is bestof-sql. I don't believe that we configured a seperate instance name. When running the install I simply get (Local), as I said above the -i option doesn't seem to change where the product tries to install. Any assistance would be appreciated.
  
  Thanks,
  Gavin

  UKS-Gavin September 26, 2006 16:18

  - 0 +
• 
  Let's try to determine if the problem is with the GUI, or with the setup.
  
  If you connect to the SQL Server virtual server using Query Analyzer or Management Studio, are you at least able to backup a database using sqlbackup e.g.
  
  EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = [c:\model.sqb] WITH INIT" '
  
  Do ensure that the service has been started, and the service name should read 'SQL Backup Agent'.

  petey September 27, 2006 05:23

  - 0 +
• 
  Hi Petey,
  
  This is part of the problem, the sql backup services don't install.
  
  Cheers,
  Gavin

  UKS-Gavin September 27, 2006 05:55

  - 0 +
• 
  When you run SQBServerSetup on the active node, and select the (LOCAL) instance, what errors do you encounter during the installation?

  petey September 27, 2006 11:56

  - 0 +
• 
  Hi Petey,
  
  We got round this in the end by setting up a single SQL server, performing the restore and then using the standard export tools.
  
  Thanks for your assistance though.
  
  Regards,
  Gavin

  UKS-Gavin September 27, 2006 11:57

  - 0 +

Add comment

Please sign in to leave a comment.