X hits on this document

704 views

0 shares

0 downloads

0 comments

6 / 200

6

Chapter 4

Chapter 5

Client configuration .................................................................................... 40 SQL Server privileges .......................................................................................... 42 Setting the SQL Server login for scheduled operations ......................... 43 Authorizing scheduled operations (for sites with SQL Server security

restrictions) 43 .......................................................................................... How to use standard SQL Server security ................................................ 44 Performance factors ............................................................................................ 45 Buffer space parameters ............................................................................. 45 Backup stripes .............................................................................................. 46 Shared memory usage ................................................................................. 46 Alternate buffer method ............................................................................. 46 Page verification .......................................................................................... 47 Instant data file initialization .................................................................... 48 Using read-write and read-only filegroups ............................................. 48 Backing up SQL Server in an environment with log shipping ...................... 48

Backup and recovery concepts

Overview ............................................................................................................... 49 SQL Server system database types ............................................................ 50

Database backups ........................................................................................ 50 Filegroup backups ........................................................................................ 51 Differential backups .................................................................................... 52 Protecting files and filegroups .......................................................................... 52 Recovery considerations for files and filegroups ........................................... 53 Reducing backup size and time by using read-only filegroups (SQL

Server 2005) 54 .................................................................................................. Recovery factors .................................................................................................. 55 Transaction logs .......................................................................................... 55 Recovery strategies ..................................................................................... 55 Backing up the transaction log .................................................................. 56 Differential backups .................................................................................... 56 File and filegroup backups ......................................................................... 57 Database recovery ....................................................................................... 58 Staging recovery .......................................................................................... 58

Using NetBackup for SQL Server

Using dbbackex .................................................................................................... 61 Using client-based schedulers with dbbackex ........................................ 62 Using the NetBackup for MS SQL Client interface ......................................... 63 Starting the NetBackup MS SQL Client for the first time ..................... 63 Selecting the SQL host and instance ........................................................ 63 Backup options ............................................................................................. 65

Document info
Document views704
Page views704
Page last viewedSun Jan 22 10:23:41 UTC 2017
Pages200
Paragraphs4189
Words49499

Comments