How To Backup Microsoft SQL Server (MSSQL) With Veritas NetBackup Script Based

This article describes How to Backup Microsoft SQL Server (MSSQL) with Veritas NetBackup Script Based

Veritas Technologies LLC provides software solutions. The Company designs and develops enterprise data management software solutions that helps organizations to protect their mission-critical data, as well as offers cloud data management, data protection, compliance readiness, and storage optimization services. Veritas Technologies serves customers worldwide.

Veritas enables organisations to harness the power of their information, with solutions designed to serve the world’s largest and most complex mixed environments.

In computing, Veritas NetBackup (called Symantec NetBackup prior to Symantec’s divestiture of Veritas) is an enterprise-level heterogeneous backup and recovery suite. It provides cross-platform backup functionality to a large variety of Windows, UNIX and Linux operating systems.

Veritas NetBackup — known as Symantec NetBackup from 2005 to 2016 — is a backup and recovery software suite designed for enterprise users.

NetBackup features a central master server which manages both media servers (containing the backup media) and clients. Core server platforms include Solaris, HP-UX, AIX, Tru64, Linux and Windows.

NetBackup OpsCenter, which comes bundled with the NetBackup 7.0 distribution and replaces the NetBackup Operations Manager.

NetBackup: #1 in Enterprise Backup Solutions Enterprise data backup and recovery optimized for the multi-cloud.

NetBackup simplifies the protection of your information driven enterprise by automating advanced technologies and standardizing operations across applications, platforms, and virtual environments. Integrated deduplication, replication, and patent-pending virtual machine protection, helps customers improve storage efficiency, infrastructure use, and recovery times.
A single console offers multi-site monitoring, analytics, and reporting which allows customers to standardize operations and risk management. Used by global companies around the world, NetBackup easily scales to protect the largest UNIX®, Windows®, and Linux® environments.

NetBackup includes the following server and client software:
The NetBackup master server manages NetBackup backups, archives, and restores. The master server is responsible for media and device selection for NetBackup.
NetBackup Media servers are the NetBackup device hosts that provide additional storage by allowing NetBackup to use the storage devices that are attached to them.
NetBackup client software that resides on the hosts that contain data to be backed up.

SQL Server is a relational database management system (RDBMS) developed and marketed by Microsoft. As a database server, the primary function of the SQL Server is to store and retrieve data used by other applications.

Sybase and Microsoft released version 1.0 in 1989. The partnership between the two companies fell apart in the early 90s, but Microsoft kept the rights to the name SQL Server.

SQL Server is Microsoft’s relational database management system (RDBMS). It is a full-featured database primarily designed to compete against competitors Oracle Database (DB) and MySQL.

SQL Server is sometimes referred to as MSSQL and Microsoft SQL Server.

NetBackup for SQL Server extends the capabilities of NetBackup for Windows to include backups and restores of SQL Server databases. These capabilities are provided for a Windows client using either a UNIX or Windows NetBackup master server. NetBackup for SQL Server includes a client-based graphical user interface (GUI) program to perform various activities on SQL Server.

NetBackup offers the following types of SQL Server backup policies:
SQL Server Intelligent Policies. A single policy protects multiple SQL Server instances that are spread over multiple clients. You select instances for a policy from a list of instances that are automatically discovered in the NetBackup environment.
Legacy policies, using clients and batch files. These policies include a list of SQL database clients and a batch file that contains SQL backup commands to run when the backup is scheduled. The user creates this batch file manually or through the NetBackup MS SQL Client interface, which saves the options the user selects to the batch file.
NetBackup for SQL Server includes the NetBackup MS SQL Client to perform various activities on SQL Server, as follows:
Restores of databases and database components, which include transaction logs, differentials, files, and filegroups.
Configuration of restore options.
Monitoring of NetBackup for SQL Server restore operations.
(SQL Server legacy policies) Backups of databases and database components and configuration of backup options.

Now you can find some examples in this video.

Please subscribe to support our channel.
To be aware of our new videos please subscribe our channel.

Visit our website
Watch IT & Learn IT & Apply IT.