NetBackup83_AdminGuide_MSSQL_Win.pdf - Veritas NetBackup\u2122 for Microsoft SQL Server Administrator's Guide for Windows Release 8.3 Veritas NetBackup\u2122

NetBackup83_AdminGuide_MSSQL_Win.pdf - Veritas...

This preview shows page 1 out of 221 pages.

You've reached the end of your free preview.

Want to read all 221 pages?

Unformatted text preview: Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide for Windows Release 8.3 Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide Last updated: 2020-07-28 Legal Notice Copyright © 2020 Veritas Technologies LLC. All rights reserved. Veritas, the Veritas Logo, and NetBackup are trademarks or registered trademarks of Veritas Technologies LLC or its affiliates in the U.S. and other countries. Other names may be trademarks of their respective owners. This product may contain third-party software for which Veritas is required to provide attribution to the third party (“Third-party Programs”). Some of the Third-party Programs are available under open source or free software licenses. The License Agreement accompanying the Software does not alter any rights or obligations you may have under those open source or free software licenses. Refer to the Third-party Legal Notices document accompanying this Veritas product or available at: The product described in this document is distributed under licenses restricting its use, copying, distribution, and decompilation/reverse engineering. No part of this document may be reproduced in any form by any means without prior written authorization of and its licensors, if any. THE DOCUMENTATION IS PROVIDED "AS IS" AND ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE DISCLAIMED, EXCEPT TO THE EXTENT THAT SUCH DISCLAIMERS ARE HELD TO BE LEGALLY INVALID. SHALL NOT BE LIABLE FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS DOCUMENTATION. THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS SUBJECT TO CHANGE WITHOUT NOTICE. The Licensed Software and Documentation are deemed to be commercial computer software as defined in FAR 12.212 and subject to restricted rights as defined in FAR Section 52.227-19 "Commercial Computer Software - Restricted Rights" and DFARS 227.7202, et seq. "Commercial Computer Software and Commercial Computer Software Documentation," as applicable, and any successor regulations, whether delivered by Veritas as on premises or hosted services. Any use, modification, reproduction release, performance, display or disclosure of the Licensed Software and Documentation by the U.S. Government shall be solely in accordance with the terms of this Agreement. 2625 Augustine Drive Santa Clara, CA 95054 Technical Support Technical Support maintains support centers globally. All support services will be delivered in accordance with your support agreement and the then-current enterprise technical support policies. For information about our support offerings and how to contact Technical Support, visit our website: You can manage your Veritas account information at the following URL: If you have questions regarding an existing support agreement, please email the support agreement administration team for your region as follows: Worldwide (except Japan) [email protected] Japan [email protected] Documentation Make sure that you have the current version of the documentation. Each document displays the date of the last update on page 2. The latest documentation is available on the Veritas website: Documentation feedback Your feedback is important to us. Suggest improvements or report errors or omissions to the documentation. Include the document title, document version, chapter title, and section title of the text on which you are reporting. Send feedback to: [email protected] You can also see documentation information or ask a question on the Veritas community site: Veritas Services and Operations Readiness Tools (SORT) Veritas Services and Operations Readiness Tools (SORT) is a website that provides information and tools to automate and simplify certain time-consuming administrative tasks. Depending on the product, SORT helps you prepare for installations and upgrades, identify risks in your datacenters, and improve operational efficiency. To see what services and tools SORT provides for your product, see the data sheet: Contents Chapter 1 Introducing NetBackup for SQL Server ...................... 11 Overview of NetBackup for SQL Server ............................................ 11 Chapter 2 Installing NetBackup for SQL Server ........................... 15 Planning the installation of NetBackup for SQL Server ......................... 15 Verifying the operating system and platform compatibility ...................... 17 Chapter 3 Managing SQL Server objects for use with SQL Server Intelligent Policies .......................................... 18 About the Applications utility ........................................................... About discovery of SQL Server objects ............................................. Discovering instances on demand ............................................. Discover advanced or basic availability groups on demand ............. Discover read-scale availability groups ....................................... About registering SQL Server instances and availability group replicas ........................................................................................... About credentials used with SQL Server Intelligent Policy ............... Configuring the NetBackup services for SQL Server backups and restores .......................................................................... Configuring local security privileges for SQL Server ....................... Registering a SQL Server instance or availability replica ................. Registering instances or availability replicas with an instance group ..................................................................................... Registering instances or availability replicas automatically .............. Authorizing a DBA to register instances or availability replicas with the nbsqladm command ..................................................... Deleting SQL Server objects from the Applications utility ...................... Manually add a SQL Server instance ................................................ Deactivating or activating an instance ............................................... Cleaning up instances ................................................................... 18 19 20 20 20 21 21 25 26 27 28 31 32 32 33 34 35 Contents Chapter 4 Configuring backups with SQL Server Intelligent Policy ............................................................................... 36 About SQL Server Intelligent Policies ............................................... Creating a SQL Server Intelligent Policy ............................................ About policy attributes ................................................................... About schedule properties .............................................................. Schedule backup types for SQL Server Intelligent Policies .................... Adding instances to a policy ........................................................... Adding databases to a policy .......................................................... Adding filegroups or files to the backup selections list .......................... Manually adding files or filegroups to the backup selections list .............. Adding instance groups to a backup policy ........................................ About tuning parameters for SQL Server backups ............................... Configuring multistriped backups of SQL Server ........................... Backing up read-only filegroups ...................................................... Backing up read-write filegroups ...................................................... Chapter 5 Configuring host properties and job settings ............. 56 Configuring mappings for restores of a distributed application, cluster, or virtual machine .................................................................. Reviewing the auto-discovered mappings in Host Management ............. Configuring the number of jobs allowed for backup operations ............... Configuring the Maximum jobs per client setting ................................. Chapter 6 37 37 38 39 40 42 43 46 48 48 49 53 53 54 Performing restores of SQL Server 56 57 62 63 ............................. 65 Starting the NetBackup MS SQL Client for the first time ........................ Selecting the SQL Server host and instance ...................................... 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 .................................. 66 66 67 69 71 72 72 73 74 74 75 75 77 79 5 Contents Redirecting a SQL Server database to a different host ......................... About selecting a master server ................................................ Performing a restore of a remote SQL Server installation ...................... Restoring multistreamed SQL Server backups .................................... About using bplist to retrieve SQL Server backups .............................. About NetBackup for SQL Server backup names ................................ Chapter 7 Protecting SQL Server data with VMware backups .......................................................................... 87 About protecting SQL Server data with VMware backups ...................... Limitations of VMware application backups .................................. Installing the Veritas VSS provider for vSphere ............................. About configuring NetBackup for VMware backups that protect SQL Server .................................................................................. Configuring the NetBackup services for a VMware backup that protects 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 ...................................... Restoring SQL Server databases from a VMware backup ..................... Chapter 8 80 82 82 83 84 85 87 88 89 90 91 92 94 95 Configuring backups with Snapshot Client ................ 96 About NetBackup Snapshot Client for SQL Server .............................. 96 How SQL Server operations use Snapshot Client ................................ 97 Configuration requirements for SQL Server snapshot and Instant Recovery backups .................................................................. 99 Configuring a snapshot policy for SQL Server ................................... 100 Configuring a policy for Instant Recovery backups of SQL Server ......... 102 Using copy-only snapshot backups to affect how differentials are based .......................................................................................... 104 Creating a copy-only backup (legacy SQL Server policies) ............ 105 Creating an Instant Recovery backup that is not copy-only (legacy SQL Server policies) ....................................................... 106 About SQL Server agent grouped backups (legacy SQL Server policies) .......................................................................................... 106 Requirements for a grouped backup ......................................... 107 Viewing the progress of a grouped backup ................................. 107 Restoring a database backed up in a group ............................... 108 6 Contents Chapter 9 Protecting SQL Server availability groups ................ 110 About protecting SQL Server availability groups ................................ Protecting SQL Server availability groups with intelligent policies .......... Prerequisites for protecting SQL Server availability groups ............ Configuring a backup policy to protect a SQL Server availability group ........................................................................... Protecting SQL Server availibility groups with legacy policies ............... 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) ................................................... Protect a SQL Server availability group that crosses NetBackup domains ............................................................................. Browsing for SQL Server availability group backup images .................. Restoring a SQL Server availability database to a secondary replica .......................................................................................... Restoring a SQL Server availability database to the primary and the secondary replicas ................................................................ Restoring an availability database when an availability group crosses NetBackup domains .............................................................. Chapter 10 110 112 112 113 117 118 123 126 127 128 129 130 Protecting SQL Server in a cluster environment .......................................................................................... 132 Configuring backups of clustered SQL Server instances (SQL Server Intelligent Policy) ................................................................. 132 Configuring backups of clustered SQL Server instances (legacy SQL Server policies) .................................................................... 134 Performing a restore of a virtual SQL Server instance ........................ 135 Chapter 11 Configuring backups with legacy SQL Server policies using clients and batch files .................... 136 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 ...................... Keywords and values used in batch files .................................... Creating a batch file .............................................................. Running batch files ............................................................... 137 137 138 139 140 141 153 154 7 Contents Adding a new SQL Server legacy policy .......................................... About schedule properties ........................................................... Legacy policy backup types .................................................... Converting differential backups to full backups ............................ Configuring an application backup schedule ............................... Example application backup schedule ....................................... Configuring automatic backup schedules ................................... Example automatic backup schedule ........................................ Adding clients to a policy .............................................................. Adding batch files to the backup selections list ................................. Selecting the SQL Server host and instance ..................................... Options for SQL Server backup operations ...................................... About viewing the properties of the objects selected for backup ............ Performing user-directed backups of SQL Server databases ............... Performing user-directed backups of SQL Server transaction logs .................................................................................... Performing user-directed backups of SQL Server database filegroups ...................................................................... Performing user-directed backups of read-only filegroups ............. Performing user-directed backups of read-write filegroups ............. Performing user-directed backups of SQL Server database files .................................................................................... Performing partial database backups ........................................ 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 ................ Chapter 12 154 155 156 157 158 158 159 159 160 161 162 163 166 167 167 168 169 170 171 172 173 174 175 Using NetBackup for SQL Server with multiple NICs ............................................................................... 177 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) ......................... 177 179 180 181 182 183 184 184 8 Contents Performing restores of a SQL Server cluster when you have multiple NICs .................................................................................. 186 Chapter 13 Performance and troubleshooting .............................. 189 What are the components of NetBackup for SQL Server? ................... How does NetBackup for SQL Server back up a database? ................. How does NetBackup for SQL Server recover a database? ................. Performing a manual backup ......................................................... About debug logging for SQL Server troubleshooting ......................... Setting the debug level .......................................................... Veritas VSS provider logs ....................................................... About NetBackup for SQL performance factors ................................. About monitoring NetBackup for SQL Server operations ..................... Setting the maximum trace level for NetBackup for SQL Server ............ Troubleshooting credential validation ............................................. Reporting of unsuccessful filegroup or file backups ........................... About minimizing timeout failures ...
View Full Document

  • Spring '17
  • kevin croteu
  • Microsoft SQL Server

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture