Forum Discussion

klunkySQL's avatar
klunkySQL
Level 3
11 years ago

Use a diferent BROWSECLIENT from SQLHOST

Good afternoon. 
 
I wonder if there is any solution to this problem:
 
I have 3 SQL instances with different HOST's and I would always use the same BROWSECLIENT, ie all backups of all SQLHOST's would be stored in the same BROWSECLIENT. 
 
Is it possible? 
 
example:
 
SQLHOST "Instance1" -> makes backup to BROWSECLIENT "VirtualMachine" 
SQLHOST "Instance2" -> makes backup to BROWSECLIENT "VirtualMachine" 
SQLHOST "Instance3" -> makes backup to BROWSECLIENT "VirtualMachine"
  • Please stick to supported backup and restore methods. That is only way to ensure support should anything go wrong.

    SQLHOST and BROWSECLIENT will be local hostname on each SQL server where instances need to be backed up.

    When you want to restrore, BROWSECLIENTneeds to correspond with source client name.

    Steps are explained under Redirecting a restore to a different host in the NBU for SQL manual.

  • Klunky SQL, I think I understand what you are trying to explain here. Here's the scenerio in my environment. I have a single host" though in clusters" hosting different instances- Atleast minimum of 4. As Marianne & Mark has explained above, all you have to do is create separate batch scripts for each of the DBs/instances residing in the same physical server. You can have your backup policy pointing to the 3 scripts as per your need or create separate policies. SQLHOST & BROWSECLIENT definitely needs to have the names of each of the respective instances. But obviously, the 3 instance can residing on a single physical server.

    Hope this helps.

  • Please stick to supported backup and restore methods. That is only way to ensure support should anything go wrong.

    SQLHOST and BROWSECLIENT will be local hostname on each SQL server where instances need to be backed up.

    When you want to restrore, BROWSECLIENTneeds to correspond with source client name.

    Steps are explained under Redirecting a restore to a different host in the NBU for SQL manual.

  • No, sorry, can't see this working.  Cannot direct backups of multiple SQL servers to a single host.  You can redirect restores as Mariannes points out above. 

  • Thanks once again for the input :)

    Maybe im not explaining that well... the objective is to have the XCLIENT with backups of the 3 instances and when i need to restore i will read from XCLIENT to one of my instances.

    How can a policy help me in this matter ?

    Want me to paste here some sample scripts of my idea ?

  • I am with Marianne on this one - really cannot - or at least should not be done

    Keep it as it is - you can still have all three servers in one policy as long as they use the same name for the batch file and it is in the same location

  • It cannot be done in this way.

    When you want to restore on XCLIENT, you need to perform steps in the manual for Redirected restore.
    (Link in my previous post).

  • Hello, thanks for all the input.

    @Marianne, no this is not a cluster, its 3 separate machines, that i want them all to backup to the same BROWSECLIENT.

    Like this:

    1 instance in Floor A

    1 instance in Floor B

    1 instance in Floor C.

     

    When i backup all instance i want them all to go to, to the same BROWSECLIENT ( lets call XCLIENT ). This way i have all my instances in the same "server".

     

    If i need to RESTORE any DB in any SQL Instance, i will read all my BACKUPS from the XCLIENT, when i have the FloorA Backups, FloorB Backups and FloorC Backups

  • If the client specified in the policy is the virtual name and that same name is used in the bch file then you should be fine - keep the case the same though!

    You may want a policy for each instance so that each points to its own bch file

    But there shouldnt be any real issues with this - all covered in the admin guide linked by Marianne

  • Sounds like you need to backup a SQL cluster?

    If so, please go through this section in NBU for SQL Admin Guide: http://www.symantec.com/docs/DOC5173

    Chapter 8 Using NetBackup for SQL Server with clustering solutions
     
    SQLHOST and BROWSECLIENT should both be set "VirtualMachine" linked to instance name.
    To enable restores from any of the nodenames, you need to create altnames entries on the master.
    Details in above manual.