NetBackup SQL Server backup script | An Introduction

Here is an introduction to NetBackup SQL Server backup script by our in-house experts. Our SQL Server Support team is here to lend a hand with your queries and issues.

An introduction to NetBackup SQL Server backup script

Did you know that NetBackup SQL Server is responsible for extending the features of NetBackup for Windows? This includes features like taking backups and restoring SQL Server databases.

In other words, these features are offered to a Windows client via a UNIX or Windows NetBackup master server. Furthermore, NetBackup for SQL Server has a GUI as well.

Let’s take a look at the two types of SQL Server backup policies:

• SQL Server Intelligent Policies.
• Legacy policies

Additionally, NetBackup for SQL Server comes with NetBackup MS SQL Client. It carries out different activities on SQL Server, as seen below:

• Restores database components and databases.
• Configures restore option.
• Monitors NetBackup for SQL Server restore operations.

We can easily generate a NetBackup script via a SQL Server Agent Job.

We can adjust the above script as per our requirements and add this to a job step. This will result in a flawless NetBackup script. Next, we have to save the code in a file named full_script.sql.

After that, we have to run SQLCMD code in order to generate full_default.bch file.

SQLCMD -h-1 -i "C:\Program Files\Veritas\NetBackup\DbExt\MsSql\full_script.sql" -o "C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Full_Default.bch" -W

Remember to edit the location of the full_script.sql and full_default.bch files.

After running the above SQLCMD code, it will result in the following sample output:

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

To conclude, our Support Engineers gave us a quick look at the NetBackup SQL Server backup script and more. We were also introduced to generating NetBackup scripts using a SQL Server Agent Job.