cancel
Showing results for 
Search instead for 
Did you mean: 

How NB connects to SQL/UDB databases

prafullkshirsag
Level 3

Hi,

If someone can share how NBU and database connection happens.

Which processes are used to connect to database ?

How automatic policy get create in NBU?

How it gets delete automatically?

 

9 REPLIES 9

sri_vani
Level 6
Partner

Please verify below excellent link which talks about backup process flow chart which Marianne shared with us:

 

https://www-secure.symantec.com/connect/sites/default/files/NBU%207.x%20process%20flow%20QRC_1.pdf

prafullkshirsag
Level 3

Hi sri,

 

Thanks for sharing this link.

I am aware of the process flow in netbackup. but I want to know exact files required to make the connection between NBU and database.

My concern is how policy gets created and deleted ?

I dnt want detailed info but a rough idea.

 

rookie11
Moderator
Moderator
   VIP   

please take a look at NBU SQL admin and NBU oracle guide. Process flow diagram which explains how NBU connects to MS SQL is explained in detail. 

policy can be created and deleted in GUI .its a matter of 2-3 mouse clicks.wink

prafullkshirsag
Level 3

laugh I'm talking about automation.

If Database gets created on server then policy suppose to get create and database gets deleted then policy suppose to get delete but automatically.

 

Can you please share link for NBU SQL admin ?

sri_vani
Level 6
Partner

Sagar,

  • NetBackup for SQL Server accesses information about SQL Server using ODBC.
  • dbbackup.exe will allow t0 browse SQL Server objects, like databases, filegroups, and database files,db images..
  • dbbackup.exe will call dbbackmain.dll
  • To access the contents of the catalog the GUI invokes
    dbbackmain.dll, which uses VxBSA function calls to access the NetBackup
    Server database manager.
  • we need below processes
Please verify below image:
 
 

 

sri_vani
Level 6
Partner

Please find the netbackup sql admin guide

http://www.symantec.com/business/support/index?page=content&id=DOC5173

prafullkshirsag
Level 3

Hey Sri,

 

Thanks for giving the way. I had this document saved and I went thought the same part which you just posted.

 

Appreciated :)

sri_vani
Level 6
Partner

Hello Sagar,

If your request is fulfilled, pls mark the respective post as a solution.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

My concern is how policy gets created and deleted ? 

There is nothing about this process that can be automated.
SQL dba needs to work with backup admin to create/update/delete policy.

If backup script on client contains $all for database entry, all SQL databases will be backed up, even if dba's create and delete individual databases.