Forum Discussion

Sisso's avatar
Sisso
Level 5
11 years ago

Where is netbackup hold the information of sql backups

Hello,

 

As you all know, Netbackup sql agent can restore sql DB even if the DB was erased.

Thus, netbackup necessarily holds all the information of the db for the specific time of the backup.

Please, someone knows where is the netbackup hold this information, like number of mdf/ndf/lsf files, old paths of this files?

  • That information is stored in the Netbackup catalog [install_base]/netbackup/db/images/{client_name}

    Do not delete or alter files in this location, is not needed or supported by Symantec.

    See tech note: 

    http://www.symantec.com/docs/HOWTO34452

  • That information is stored in the Netbackup catalog [install_base]/netbackup/db/images/{client_name}

    Do not delete or alter files in this location, is not needed or supported by Symantec.

    See tech note: 

    http://www.symantec.com/docs/HOWTO34452

  • Hi Nicolai,

     

    Thank you for help, but there is maybe a way to get this information that includes in thos file by command line?

     

     

  • That would be the normal netbackup command like bpimagelist,bplist and bpflist. Or the catalog part of the Netbackup gui

    See a examples here : 

    http://www.mass.dk/netbackup/guides/47-converting-ms-sqls-nbimage-to-netbackup-backupid.html

    http://www.mass.dk/netbackup/quick-hints/94-how-to-find-ms-sql-database-files-using-bplist.html

    Is there a specific thing you want to do ?

     

  • Only part of database info is held in NBU catalogs. Rest is in the SQL master database.

    Most importand SQL database is master. 
    This database holds information about the file locations of the user databases, as well as logon accounts, server configuration settings, and a number of other items such as linked servers and startup stored procedures. 
    (Copied from: http://blog.idera.com/sql-server/introduction-to-sql-server-system-databases/ )

    So, it it extremely important to backup this database regularly. This is the 1st database to be restored in case of disaster.

  • Although SQL Backups are performed using the SQL Agent GUI you can also view them in the BAR GUI - just select the client and the policy type as MS-SQL-Server

    You cannot restore them from there but you can see the details