X hits on this document

495 views

0 shares

0 downloads

0 comments

9 / 200

Chapter 9

Chapter 10

Chapter 11

Appendix A

Configuring a snapshot backup .......................................................................145 Configuration requirements ....................................................................145 Configuration steps ...................................................................................145 Configuring Snapshot Client policies for NetBackup for SQL Server 146

Other applications of NetBackup for SQL Server

Performing backups and restores in an SAP environment .........................151 Policy configuration ..................................................................................152 Creating batch files to be used in automatic backup schedules .........152 Monitoring backups ...................................................................................153 Restoring the R/3 database ......................................................................153 Using NetBackup to restore SQL Server from Backup Exec images ..........156

Requirements for restoring Backup Exec images .................................156 Limitations when restoring Backup Exec images .................................156 Restoring from Backup Exec images .......................................................156

Using NetBackup for SQL Server with database mirroring

Configuring NetBackup to support database mirroring ..............................171 Impact on backup ...............................................................................................172 Impact on recovery ............................................................................................173

Troubleshooting

Progress reports created for NetBackup for SQL Server on the client ......175 Debug logging .....................................................................................................178

Backup operation debug logging .............................................................178 Restore operation debug logging .............................................................179 Setting the debug level ..............................................................................179 NetBackup reports .............................................................................................180 Minimizing timeout failures on large database restores .............................180

Sample batch files

Sample 1 - Simple script to back up a database named BUSINESS ............181 Sample 2 - Simple script to restore a database named pubs ......................182 Sample 3 - Perform a striped database backup. allow multiple internal

buffers per stripe .......................................................................................183 Sample 4 - Restore a database from multiple stripes ...................................183 Sample 5 - Restore a database transaction log up to a point in time .........184 Sample 6 - Perform an operation and specify the userid and password

to use to SQL Server ..................................................................................185 Sample 7 - Perform multiple operations in sequence ..................................186 Sample 8 - Perform a set of operations in parallel .......................................188

9

Document info
Document views495
Page views495
Page last viewedWed Dec 07 20:54:52 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments