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.
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.
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.
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://www.sdk-it.com
Watch IT & Learn IT & Apply IT.
Enjoy!