Computer Associates SQLSTQ99000600 Microsoft SQL Guide - Page 45

: Restoring Microsoft SQL Server Databases

Page 45 highlights

Chapter 4: Restoring Microsoft SQL Server Databases This section contains information about restoring databases and Transaction logs using CA ARCserve Backup, the Agent for Microsoft SQL Server, and Microsoft SQL Server 7.0, Microsoft SQL Server 2000, Microsoft SQL Server 2005 and Microsoft SQL Server 2008. This section contains the following topics: Restore Options (see page 46) Database File Options (see page 54) Restore Databases Using Restore by Tree Method (see page 57) Restore Databases Using Restore by Session Method (see page 60) SQL Agent Filter Options (see page 63) Restore to Alternate Disk Locations Using Automatic Selection (see page 63) Restore to Alternate Disk Locations by Individual Session (see page 64) Perform an Offline Torn Page Restore Using Microsoft SQL Server 2005 or 2008 (see page 68) Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or Developer Editions (see page 70) Chapter 4: Restoring Microsoft SQL Server Databases 45

  • 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

Chapter 4: Restoring Microsoft SQL Server Databases
45
Chapter 4: Restoring Microsoft SQL
Server Databases
This section contains information about restoring databases and Transaction logs
using CA ARCserve Backup, the Agent for Microsoft SQL Server, and Microsoft
SQL Server 7.0, Microsoft SQL Server 2000, Microsoft SQL Server 2005 and
Microsoft SQL Server 2008.
This section contains the following topics:
Restore Options
(see page 46)
Database File Options
(see page 54)
Restore Databases Using Restore by Tree Method
(see page 57)
Restore Databases Using Restore by Session Method
(see page 60)
SQL Agent Filter Options
(see page 63)
Restore to Alternate Disk Locations Using Automatic Selection
(see page 63)
Restore to Alternate Disk Locations by Individual Session
(see page 64)
Perform an Offline Torn Page Restore Using Microsoft SQL Server 2005 or 2008
(see page 68)
Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008
Enterprise, Data Center, or Developer Editions
(see page 70)