Please enter search query.
Search <book_title>...
Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide
Last Published:
2017-10-04
Product(s):
NetBackup (8.1)
- Introducing NetBackup for SQL Server
- Installing NetBackup for SQL Server
- Instance Management for SQL Server Intelligent Policies
- About Instance management for a SQL Server Intelligent Policy
- About credentials used with SQL Server Intelligent Policy
- Configuring the NetBackup services for SQL Server backups and restores (SQL Server Intelligent Policy)
- Configuring local security privileges for SQL Server (SQL Server Intelligent Policy)
- About the NetBackup Discovery Service (NetBackup for SQL)
- Viewing the SQL Server instances and instance groups in instance management
- About registering SQL Server instances
- Manually adding a SQL Server instance in instance management
- Configuring SQL Server backups with SQL Server Intelligent Policy
- About SQL Server Intelligent Policies
- About configuring SQL Server backups with SQL Server Intelligent Policy
- Adding a new SQL Server Intelligent Policy
- About policy attributes for NetBackup for SQL Server
- About schedule properties (SQL Server Intelligent Policy)
- Schedule backup types for SQL Server Intelligent Policies
- Adding instances to a policy (SQL Server Intelligent Policy)
- Adding databases to a policy (SQL Server Intelligent Policy)
- Instance properties
- Backup Selections tab
- Adding SQL Server filegroups or files to the backup selections list
- Manually adding SQL Server files or filegroups to the backup selections list (SQL Server Intelligent Policy)
- Adding instance groups to a SQL Server Intelligent Policy
- About tuning parameters for SQL Server backups
- Backing up read-only filegroups (SQL Server Intelligent Policies)
- Backing up read-write filegroups (SQL Server Intelligent Policies)
- Configuring NetBackup for SQL Server
- Configuring mappings for restores of a distributed application, cluster, or virtual machine
- Reviewing the auto-discovered mappings in Host Management
- About NetBackup for SQL performance factors
- Configuring the number of jobs allowed for backup operations
- Configuring the Maximum jobs per client setting
- Configuring multistriped backups of SQL Server
- Performing a manual backup (NetBackup for SQL Server)
- Performing restores of SQL Server
- Starting the NetBackup MS SQL Client for the first time (legacy SQL Server policies)
- Selecting the SQL Server host and instance (SQL Server restores)
- Browsing for SQL Server backup images
- Options for NetBackup for SQL Server restores
- Restoring a SQL Server database backup
- Staging a full SQL Server database recovery
- Restoring SQL Server filegroup backups
- Recovering a SQL Server database from read-write filegroup backups
- Restoring SQL Server read-only filegroups
- Restoring SQL Server database files
- Restoring a SQL Server transaction log image without staging a full recovery
- Performing a SQL Server database move
- About performing a SQL Server page-level restore
- Configuring permissions for redirected restores
- Redirecting a SQL Server database to a different host
- Performing a restore of a remote SQL Server installation
- About restores of a database that contain full-text catalog
- Restoring multistreamed SQL Server backups
- Protecting SQL Server data with VMware backups
- About protecting SQL Server data with VMware backups
- About configuring NetBackup for VMware backups that protect SQL Server
- Using NetBackup Accelerator to increase speed of full VMware backups (NetBackup for SQL Server)
- Installing the Veritas VSS provider for vSphere (NetBackup for SQL)
- Configuring the NetBackup services for VMware backups that protect SQL Server
- Configuring a VMware backup policy to protect SQL Server
- Configuring a VMware policy to protect SQL Server using Replication Director to manage snapshot replication
- About truncating logs with a VMware backup that protects SQL Server
- Restoring SQL Server databases from a VMware backup
- Using NetBackup for SQL Server with Snapshot Client
- About NetBackup Snapshot Client for SQL Server
- How SQL Server operations use Snapshot Client
- Configuration requirements for SQL Server snapshot and Instant Recovery backups
- Configuring a snapshot policy for SQL Server
- Configuring a policy for Instant Recovery backups of SQL Server
- Using copy-only snapshot backups to affect how differentials are based
- About SQL Server agent grouped backups (legacy SQL Server policies)
- Protecting SQL Server in high availability (HA) environments
- About SQL Server high availability (HA) environments
- About using NetBackup to protect SQL Server availability groups
- Limitations of backups of availability groups
- About protecting the preferred replica in a SQL Server availability group (legacy backup policies)
- About protecting a specific node in a SQL Server availability group (legacy backup policies)
- Configuring SQL Server backups when an availability group crosses NetBackup domains
- Restoring a SQL Server availability group database to the primary and the secondary replicas
- Restoring a SQL Server availability group database to a secondary replica
- Restoring an availability group database when an availability group crosses NetBackup domains
- Configuring backups of clustered SQL Server instances (SQL Server Intelligent Policy)
- Configuring backups of clustered SQL Server instances (legacy SQL Server policies)
- Performing a restore of a virtual SQL Server instance
- About NetBackup for SQL Server with database mirroring
- Configuring NetBackup to support database log-shipping
- Backing up SQL Server in an environment with log shipping
- Backup and recovery concepts
- Overview of SQL Server backup and recovery concepts
- What are the components of NetBackup for SQL Server?
- How does NetBackup resolve SQL Server host and instance names?
- How does NetBackup for SQL Server back up a database?
- How does NetBackup for SQL Server recover a database?
- Protecting SQL Server files and filegroups
- About recovery considerations for SQL Server files and filegroups
- Reducing backup size and time by using read-only filegroups
- What factors affect the data transfer rate during a SQL Server backup or restore operation?
- About recovery factors for SQL Server
- Using NetBackup for SQL Server with multiple NICs
- About configuration of SQL Server backups with multiple NICs
- Configuring the NetBackup client with the private interface name
- Configuring backups of SQL Server when you have multiple NICs (SQL Server Intelligent Policies)
- Configuring backups for SQL Server when you have multiple NICs (legacy SQL Server policies)
- Performing restores of SQL Server when you have multiple NICs
- Configuring backups of a SQL Server cluster when you have multiple NICs (SQL Server Intelligent Policies)
- Configuring backups of a SQL Server cluster when you have multiple NICs (legacy SQL Server policies)
- Creating a batch file for backups of a SQL Server cluster when you have multiple NICs (legacy SQL Server policies)
- Performing restores of a SQL Server cluster when you have multiple NICs
- Configuring backups with legacy SQL Server policies using clients and batch files
- About legacy SQL Server policies
- About configuring backups with legacy SQL Server policies
- Configuring the NetBackup services for SQL Server backups and restores (legacy SQL Server policies)
- About SQL Server security with NetBackup legacy backup policies
- About using batch files with NetBackup for SQL Server
- Adding a new SQL Server legacy policy
- About schedule properties (legacy SQL Server policies)
- SQL Server backup types (for legacy policies)
- Converting differential backups to full backups
- Configuring an application backup schedule (NetBackup for SQL Server)
- Example application backup schedule (NetBackup for SQL Server)
- Configuring automatic backup schedules (NetBackup for SQL Server)
- Example automatic backup schedule (NetBackup for SQL Server)
- Adding clients to a policy
- Adding batch files to the backup selections list (NetBackup for SQL Server legacy policy)
- Selecting the SQL Server host and instance (SQL Server backups with legacy backup policies)
- Options for SQL Server backup operations
- About viewing the properties of the objects selected for backup
- Performing user-directed backups of SQL Server databases
- Backing up SQL Server transaction logs
- Backing up SQL Server database filegroups
- Backing up read-only filegroups (legacy SQL Server backup policies)
- Backing up read-write filegroups (legacy SQL Server backup policies)
- Backing up SQL Server database files
- Performing partial database backups (SQL Server legacy backup policies)
- Performing a backup of a remote SQL Server installation
- About file checkpointing with NetBackup for SQL Server
- About automatic retry of unsuccessful SQL Server backups
- Performing user-directed operations with dbbackex
- Using bplist to retrieve a list of SQL Server backups
- SQL Server backups and restores in an SAP environment (legacy SQL Server policies)
- About SQL Server backups and restores in an SAP environment
- About manual backups of SQL Server in an SAP environmentAbout manual backups of SQL Server in an SAP environment
- About policy configuration for SQL Server in an SAP environment
- Troubleshooting
- About monitoring NetBackup for SQL Server operations
- About NetBackup reports for SQL Server troubleshooting
- About debug logging for SQL Server troubleshooting
- Setting the maximum trace level for NetBackup for SQL Server
- Troubleshooting credential validation with instance management (NetBackup for SQL Server)
- About minimizing timeout failures on large SQL Server database restores
- Troubleshooting VMware backups and restores of SQL Server
- Delays in completion of backup jobs
- SQL Server log truncation failure during VMware backups of SQL Server
- SQL Server restore fails when you restore a SQL Server compressed backup image as a single stripe or with multiple stripes
- Incorrect backup images are displayed for availability group clusters
- A restore of a SQL Server database fails with Status Code 5, or Error (-1), when the host name of the SQL Server or the SQL Server database name has trailing spaces
- A move operation fails with Status Code 5, or Error (-1), when the SQL Server host name, the database name, or the database logical name has trailing spaces
- Disaster recovery of a SQL Server
- NetBackup for SQL dialog box topics
- NetBackup for SQL dialog box fields
- Backup History Options field descriptions
- Manage Scripts field descriptions
- NetBackup client properties field descriptions
- Viewing properties of objects selected for restore
- About selecting database objects for restore
- SQL Server connection properties
- SQL Server connection properties field descriptions
- Appendix A. Sample batch files
- About sample backup batch files for legacy SQL Server policies
- Script to back up a database (NetBackup for SQL Server)
- Script to perform a striped database backup and allow multiple internal buffers per stripe (NetBackup for SQL Server)
- Script to perform an operation and specify the user ID and password to use to SQL Server (NetBackup for SQL Server)
- Script to perform multiple operations in sequence (NetBackup for SQL Server)
- Script to perform a set of operations in parallel (NetBackup for SQL Server)
- Script to specify the maximum transfer size and block size for a backup (NetBackup for SQL Server)
- Script that uses environment variables to exclude instances and databases from backup(NetBackup for SQL Server)
- About sample restore batch files
- Script to restore a database (NetBackup for SQL Server)
- Script to restore a database from multiple stripes (NetBackup for SQL Server)
- Script to stage a database restore from a filegroup backup, several file backups, and transaction log backups (NetBackup for SQL Server)
- Script to restore a database transaction log up to a point in time (NetBackup for SQL Server)
- Script to stage a database restore from a database backup, a differential backup, and a series of transaction backups (NetBackup for SQL Server)
- About sample backup batch files for legacy SQL Server policies
- Appendix B. Multiplexed backups
- Appendix C. Register authorized locations
Backing up read-write filegroups (SQL Server Intelligent Policies)
When you separate read-only and read-write filegroups in your backup strategy, you can reduce total media usage and the total time you spend on backup operations. More information is available on backing up read-only filegroups.
Note:
Immediately back up any filegroup when you change it from read-write to read-only.
To back up read-write filegroups
- Create a new policy or open the policy you want to configure.
- Select the policy attributes.
- Create a Full Backup, Differential Incremental Backup, and Transaction Log backup schedule.
- On the Instances and Databases tab, choose to Protect instances.
- Add the instances or the databases that contain the read-write filegroups.
See Adding instances to a policy (SQL Server Intelligent Policy).
- On the Backup Selections tab, select Whole database.
- Click the Microsoft SQL Server tab.
- Check Skip read-only file groups.
- When you have completed the policy configuration, click OK.