blog
June 11, 2019

This article describes How to Backup Microsoft SQL Server (MSSQL) with Veritas NetBackup Intelligent Policy

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.

Veritas Technologies empowers businesses of all sizes to discover the truth in information – their most important digital asset. Using the Veritas platform, customers can accelerate their digital transformation and solve pressing IT and business challenges including multi-cloud data management, data protection, storage optimisation, compliance readiness and workload portability – with no cloud vendor lock-in. Ninety-seven percent of Fortune 100 companies rely on Veritas today to reveal data insights that drive competitive advantage.

Technical Director Nigel Dutt approached Edward Forwood of broker Durlacher with a proposal to start a company to develop and sell the product. They consequently acquired the rights to the product and formed kVault Software Limited in late 1999 with initial funding from Durlacher. The four years from 2000–2004 saw greatly improved sales and eventual acquisition by VERITAS Software in 2004. Veritas was subsequently acquired by Symantec in 2005 for $13.5B. However, on February 1st 2016, Symantec completed its sale of Veritas to the Carlyle group for $7.4B and Enterprise Vault again reverted to being a Veritas product.

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. When security giant Symantec acquired Veritas for $13.5 billion in 2005, the NetBackup product was renamed Symantec NetBackup. In 2016, when Symantec spun out its Veritas storage unit, NetBackup again became known as Veritas NetBackup.

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[1] (NOM) component used in previous versions, can manage multiple NetBackup environments. NetBackup comes with support for many hardware devices like tape drives, tape libraries, disk units. It supports, among many[quantify] other features, hot backups for major database products like Oracle; it can natively backup and restore the virtual machines of major virtualization products like VMware Infrastructure, can use Network Data Management Protocol (NDMP), and has tape vaulting. NetBackup also enables LAN-free and server-free backups in SAN fabric environments.

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.

Like all major RBDMS, SQL Server supports ANSI SQL, the standard SQL language. However, SQL Server also contains T-SQL, its own SQL implemention. SQL Server Management Studio (SSMS) (previously known as Enterprise Manager) is SQL Server's main interface tool, and it supports 32-bit and 64-bit environments.
SQL Server is sometimes referred to as MSSQL and Microsoft SQL Server.

There are many different versions of Microsoft SQL Server, catering for different workloads and demands. A data centre version is tailored to higher levels of application support and scalability, while the Express version is a scaled down, free edition of the software.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).

A SQL Server Intelligent Policy lets you create a single policy to protect multiple SQL Server instances or the databases in an instance. These instances can be spread over multiple clients. You can select SQL Server instances for a policy from a list of instances that are automatically discovered in the NetBackup environment.

The SQL Server Intelligent Policy includes the following criteria:
Storage unit and media to use
Policy attributes
Backup schedules: Full, differential-incremental, transaction log
Instances, databases in an instance, or instance groups to back up
Backup selections: Whole database, filegroups, or files
NetBackup offers the following ways to configure a SQL Server policy:
The Policy Configuration Wizard of the NetBackup Administration Console: The wizard guides you through the setup process by automatically choosing the best values for most configurations.

The SQL Server Policy utility of the NetBackup Administration Console: This utility contains all the settings and parameters you need to create or change a SQL Server Intelligent Policy.

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 https://sdk-it.com
Visit our youtube channel
Watch IT & Learn IT & Apply IT.

Enjoy!