Computer Associates SQLSTQ99000600 Microsoft SQL Guide - Page 60

Restore Databases Using Restore by Session Method, Agent for Microsoft SQL Server Guide

Get Computer Associates SQLSTQ99000600 - Unicenter SQL-Station 6.0.0 PDF manuals and user guides
UPC - 757943257441
View all Computer Associates SQLSTQ99000600 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 60 highlights

Restore Databases Using Restore by Session Method Restore Databases Using Restore by Session Method To perform a restore operation using Restore by Session method 1. On the Restore Manager Source tab, select Restore by Session from the drop-down list. A list of the media you have used when backing up with CA ARCserve Backup opens. 2. To create a filter to view only the sessions from a specific server or the sessions from a specific database on a specific server, perform the following procedure: a. Select the Filter tab. The Filter dialog opens. b. Click the SQL Agent Filter tab. The SQL Agent Filter dialog opens. c. Enter a machine name to restore the sessions from a particular server, or a machine name and database name to restore the sessions of a particular database. If you are using Microsoft SQL Server 2000 or Microsoft SQL Server 2005, you can also enter a machine name, instance name, and database name to restore a database from a specific instance of Microsoft SQL Server. d. Click OK. Note: Once you apply the filter settings, expand the media item to view the results. If the media item was already expanded, collapse it and expand it again to see the results. 3. Expand the media containing the backup you want to restore and select the session containing the specific database or log you want to restore. Note: Microsoft SQL Server backups have one Database, Partial, Files-and-FileGroups, or Transaction log backup for each session on the media. 4. Right-click the session containing the backup session you want to restore and choose Agent Options from the pop-up window. The Agent Restore Options dialog appears. This dialog varies depending on the backup method of the session selected, and the version of SQL Server from which the database was backed up. 60 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
Restore Databases Using Restore by Session Method
60
Agent for Microsoft SQL Server Guide
Restore Databases Using Restore by Session Method
To perform a restore operation using Restore by Session method
1.
On the Restore Manager Source tab, select Restore by Session from the
drop-down list. A list of the media you have used when backing up with CA
ARCserve Backup opens.
2.
To create a filter to view only the sessions from a specific server or the
sessions from a specific database on a specific server, perform the following
procedure:
a.
Select the Filter tab. The Filter dialog opens.
b.
Click the SQL Agent Filter tab. The SQL Agent Filter dialog opens.
c.
Enter a machine name to restore the sessions from a particular
server, or a machine name and database name to restore the
sessions of a particular database.
If you are using Microsoft SQL Server 2000 or Microsoft SQL Server
2005, you can also enter a machine name, instance name, and
database name to restore a database from a specific instance of
Microsoft SQL Server.
d.
Click OK.
Note:
Once you apply the filter settings, expand the media item to view the
results. If the media item was already expanded, collapse it and expand it
again to see the results.
3.
Expand the media containing the backup you want to restore and select the
session containing the specific database or log you want to restore.
Note
: Microsoft SQL Server backups have one Database, Partial,
Files-and-FileGroups, or Transaction log backup for each session on the
media.
4.
Right-click the session containing the backup session you want to restore
and choose Agent Options from the pop-up window.
The Agent Restore Options dialog appears.
This dialog varies depending on
the backup method of the session selected, and the version of SQL Server
from which the database was backed up.