Computer Associates SQLSTQ99000600 Microsoft SQL Guide - Page 75

Microsoft SQL Server 2000

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 75 highlights

Microsoft SQL Server 2000, 2005, or 2008 Cluster Environment Backups 4. On the Source tab, expand the Microsoft SQL Server virtual server name, not the physical nodes or the Windows virtual server. The Microsoft SQL Server virtual server instances are located under the Microsoft SQL Server virtual server object with which they are associated. Note: It is recommended that you browse the clustered Microsoft SQL Server instances through their associated Microsoft SQL Server virtual server names only. Browsing from any other entry point may cause backup failures if the Windows virtual server or the Microsoft SQL Server virtual server moves to a different node of the cluster. It is recommended that you do not browse through the MSCS computer name for clustered Microsoft SQL Server 2000, 2005, and 2008 instances. An instance of Microsoft SQL Server 2008 Express Edition that is used as the ARCserve Database of a clustered CA ARCserve Backup installation should be browsed through the virtual server name associated with the clustered CA ARCserve Backup primary server. 5. Right-click the Microsoft SQL Server instance and select Transfer Mechanism from the pop-up window. The Transfer Mechanism dialog opens. 6. Select Virtual Devices and click OK. 7. Right-click the Microsoft SQL Server instance and select Security. The Security dialog opens. 8. Verify the security information in the Security dialog and click OK. 9. Expand the Microsoft SQL Server instance to display a list of databases, and select a database. 10. Right-click the database and select Agent Options from the pop-up window. The Agent Backup Options dialog opens. 11. Select the type of backup you want to perform, and any subset options you wish to use. For more information about backup types, see Backup Methods (see page 32). 12. If you chose the Files-and-FileGroups subset, click the Browse Files/FileGroups button. The Specify FileGroups and Files dialog opens. 13. Select the files or FileGroups you want to back up and click OK. Chapter 5: Backing Up and Restoring in Cluster Environments 75

  • 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
Microsoft SQL Server 2000, 2005, or 2008 Cluster Environment Backups
Chapter 5: Backing Up and Restoring in Cluster Environments
75
4.
On the Source tab, expand the Microsoft SQL Server virtual server name,
not
the physical nodes or the Windows virtual server. The Microsoft SQL
Server virtual server instances are located under the Microsoft SQL Server
virtual server object with which they are associated.
Note:
It is recommended that you browse the clustered Microsoft SQL
Server instances through their associated Microsoft SQL Server virtual
server names only. Browsing from any other entry point may cause backup
failures if the Windows virtual server or the Microsoft SQL Server virtual
server moves to a different node of the cluster. It is recommended that you
do not browse through the MSCS computer name for clustered Microsoft SQL
Server 2000, 2005, and 2008 instances.
An instance of Microsoft SQL Server 2008 Express Edition that is used as the
ARCserve Database of a clustered CA ARCserve Backup installation should
be browsed through the virtual server name associated with the clustered CA
ARCserve Backup primary server.
5.
Right-click the Microsoft SQL Server instance and select Transfer Mechanism
from the pop-up window.
The Transfer Mechanism dialog opens.
6.
Select Virtual Devices and click OK.
7.
Right-click the Microsoft SQL Server instance and select Security.
The Security dialog opens.
8.
Verify the security information in the Security dialog and click OK.
9.
Expand the Microsoft SQL Server instance to display a list of databases, and
select a database.
10.
Right-click the database and select Agent Options from the pop-up window.
The Agent Backup Options dialog opens.
11.
Select the type of backup you want to perform, and any subset options you
wish to use. For more information about backup types, see
Backup Methods
(see page 32).
12.
If you chose the Files-and-FileGroups subset, click the Browse
Files/FileGroups button.
The Specify FileGroups and Files dialog opens.
13.
Select the files or FileGroups you want to back up and click OK.