Forum Discussion

MollyL's avatar
MollyL
Level 2
12 years ago

Creating a native SQL Server backup file from Netbackup image

Is there a way to create a SQL Server native backup file from a previously taken Netbackup backup image?  We currently backup our SQL Server databases to disk and let Netbackup take them to tape.  We...
7.5
Agent for Microsoft SQL Server
Backup and Recovery
NetBackup
Windows Server (2003-2008)
  • Marianne's avatar
    Marianne
    12 years ago

    Just to confirm - NBU can only restore the same format that it backed up.

    If .bak was backed up, then .bak can be restored.

    If databases were backed up, then databases can be restored. They can be restored to different location which will give you the ability to create new native backup.

    Hope this answers your query?

MollyL's avatar
MollyL
Level 2
12 years ago

Marianne,

It looks like that answers my question.  It doesn't happen very often, but we have a number of third-party SQL databases and occasionally (approx. once a month), one of those vendors will ask for a dump of a given database.  For the times that they need a current backup, it won't be a big deal. We can do what you mention and just take a new native backup.  We have had times where they requested a specific backup from the previous week or month.  I was hoping there would be a way to extract the NBU image to a .bak file, but we can work around that.  We can always restore that file to another database and back that up.  Takes an extra step, but it's not impossible. 

Thanks for your help!