Is it possible to restore a SQL database backed up using the NetBackup SQL database extension back to a server as a flat file?

Article: 100029163
Last Published: 2015-01-19
Ratings: 0 0
Product(s): NetBackup & Alta Data Protection

Problem

Is it possible to restore a SQL database backed up using the NetBackup SQL database extension back to a server as a flat file?

Solution

Microsoft SQL server databases are generally composed of two separate files, an .mdf file and a .ldf file.  They can also contain one or more .ndf files.  The .mdf files are the primary data files, the .ldf files are the log files, and any .ndf files are secondary data files. When backed up using the NetBackup SQL database extension, these files are captured as a live or "hot" database, and can only be restored to a Microsoft SQL server as a database, not as the individual files.  They cannot be restored back to a regular file server as flat files.  

In order to be able to restore the individual or flat files, the Microsoft SQL server needs to be stopped, and the files captured by a normal file system backup.  Once backed up in this fashion, they could then be restored as flat files.
 

 

Was this content helpful?