Computer Associates SQLSTQ99000600 Microsoft SQL Guide - Page 136

Restore by Session Using a Separate Job for, Perform an Offline Torn Restore Using

Page 136 highlights

N No Icon in Browse Tree • 91 O ODBC settings, checking and changing • 104 Online Backup of SAP R/3 Databases • 17 Other Options • 31, 38 P Partial Backups • 17, 114, 122 Partial Restore Dependency Checklist • 128 Partitioning • 112 password changes • 57, 60, 77, 80 Perform an Offline Torn Page Restore Using Microsoft SQL Server 2005 or 2008 • 68 Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or Developer Editions • 70 Perform Disaster Recovery in Microsoft SQL Server 2000, 2005, or 2008 Cluster Environments • 83 Performance Improvement Tips • 111 post-installation procedures configuring backup and restore pa • 26 installing • 25 Post-Installation Procedures • 25 Potential Restore Problems • 99 preserving replication settings • 63 R Recovery Completion State Options • 46, 51 Recovery Models • 113 reinitializing unused pages, in reloading • 123 remote Microsoft SQL server backup • 42 Remote Protocol option • 42 remote Windows database servers, accessing • 15 replication preserving settings • 63 Replication of Microsoft SQL Server • 95 Required Full Backup • 116, 119, 120 restore automatic selection • 47 automatic selection • 47 automatic selection option • 47 automatic selection, automatic selection • 47 avoiding problems • 99 by session using separate restore job for each session • 65 by session using single restore job for each session • 64 by tree using a separate restore job for each session • 66 change password • 57 configuring parameters • 26 destination database, requirements • 123 display backup sessions of selected database • 63 failure during • 123 Keep Replication Settings option • 54 Log Point in Time option • 50 master database • 131 options • 46 overview • 123 reinitializing unused pages • 123 restore by session • 124 restore by session in Microsoft SQL Virtual Server 200 • 80 restore by tree • 124 restore by tree in a Microsoft SQL Virtual Server 2000 • 77 Restore Database Files As option • 54 Restore files to their original locations option • 57, 60, 77, 80 Restricted User Access After Restore option • 54 security • 57, 60, 77, 80 SQL Agent Filter option • 63 to alternate disk location • 63 types • 47 types of backup sessions • 124 uncommitted transactions • 123 using restore by session • 60 using restore by tree • 57, 66, 77 Version History dialog • 57 restore by session explanation • 124 procedure • 60 Restore by Session in Microsoft SQL Server 2000, 2005 or 2008 Environments • 80 Restore by Session Using a Separate Job for Each Session • 64, 65 Restore by Session Using a Single Restore Job • 64 restore by tree • 124 explanation • 124 136 Agent for Microsoft SQL Server Guide

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137

136
Agent for Microsoft SQL Server Guide
N
No Icon in Browse Tree • 91
O
ODBC settings, checking and changing • 104
Online Backup of SAP R/3 Databases • 17
Other Options • 31, 38
P
Partial Backups • 17, 114, 122
Partial Restore Dependency Checklist • 128
Partitioning • 112
password changes • 57, 60, 77, 80
Perform an Offline Torn Page Restore Using
Microsoft SQL Server 2005 or 2008 • 68
Perform an Online Torn Page Restore Using
Microsoft SQL Server 2005 or 2008
Enterprise, Data Center, or Developer
Editions • 70
Perform Disaster Recovery in Microsoft SQL
Server 2000, 2005, or 2008 Cluster
Environments • 83
Performance Improvement Tips • 111
post-installation procedures
configuring backup and restore pa • 26
install
ing • 25
Post-
Installation Procedures • 25
Potential Restore Problems • 99
preserving replication settings • 63
R
Recovery Completion State Options • 46, 51
Recovery Models • 113
reinitializing unused pages, in reloading • 123
remote Microsoft SQL server backup • 42
Remote Protocol option • 42
remote Windows database servers, accessing •
15
replication
preserving settings • 63
Replication of Microsoft SQL Server • 95
Required Full Backup • 116, 119, 120
restore
automatic selecti
on • 47
automatic selection • 47
automatic selection option • 47
automatic selection, automatic selection • 47
avoiding problems • 99
by session using separate restore job for
each session • 65
by session using single restore job for each
session • 64
by tree using a separate restore job for each
session • 66
change password • 57
configuring parameters • 26
destination database, requirements • 123
display backup sessions of selected database
• 63
failure during • 123
Keep Replication Settings option • 54
Lo
g Point in Time option • 50
master database • 131
options • 46
overview • 123
reinitializing unused pages • 123
restore by session • 124
restore by session in Microsoft SQL Virtual
Server 200 • 80
restore by tree • 124
restore by tree in a Microsoft SQL Virtual
Server 2000 • 77
Restore Database Files As option • 54
Restore files to their original locations option
• 57, 60, 77, 80
Restricted User Access After Restore option •
54
security • 57, 60, 77, 80
SQL Agent Filter option • 63
to
alternate disk location • 63
types • 47
types of backup sessions • 124
uncommitted transactions • 123
using restore by session • 60
using restore by tree • 57, 66, 77
Version History dialog • 57
restore by session
explanation • 124
procedure • 60
Restore by Session in Microsoft SQL Server
2000, 2005 or 2008 Environments • 80
Restore by Session Using a Separate Job for
Each Session • 64, 65
Restore by Session Using a Single Restore Job •
64
restore by tree • 124
explanation • 124