HP DL160 HP StorageWorks All-in-One Storage Manager user guide (452695-004, No - Page 18

Selecting a server that hosts SQL Server, Selecting SQL Server database components

Get HP DL160 - ProLiant - G5 PDF manuals and user guides
UPC - 883585847174
View all HP DL160 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 18 highlights

Accessing the Host a SQL Server Database Wizard 1. In the Actions pane, select Host a SQL Server Database. The Host a SQL Server Database Wizard welcome page opens. 2. Click Next to open the Select a SQL Server page (see "Selecting a server that hosts SQL Server" on page 18). Selecting a server that hosts SQL Server Use the Select a SQL Server page to select one of the servers that hosts SQL Server discovered on your domain by the wizard. 1. Do one of the following: • Enter the host name of a server that hosts SQL (exactly as it is registered in the domain). • Enter the IP address of a server that hosts SQL. 2. Click Next to open the Select Database Components page (see "Selecting SQL Server database components" on page 18). Selecting SQL Server database components Use the Select Database Components page to select the SQL Server database and database components you want to host on your HP Storage Server. 1. Do one of the following: • Select all components (including all of its components) by checking the box next to the component. • Select individual database components by expanding the list and checking the boxes next to the components. You must select all the database components, including the log file, in a database if you want to run backups and/or take snapshots of the database using ASM. NOTE: ASM cannot migrate system databases; for example, ASM cannot migrate master, model, msdb and tempdb. The following table lists the action ASM can perform for each database component listed. Table 4 Selecting database components to host Action Description None Allocate Space, Move Data None, Already Managed Component's check box is not selected, so ASM will not perform any action. Select check box to change action. Storage space will be allocated and configured on your HP Storage Server. Component's data will be migrated to your HP Storage Server. Component's data is already hosted on your HP Storage Server and already managed by ASM. No action is possible. 18 Hosting storage for applications and shared folders

  • 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
Accessing the Host a SQL Server Database Wizard
1.
In the Actions pane, select
Host a SQL Server Database
.
The Host a SQL Server Database Wizard welcome page opens.
2.
Click
Next
to open the
Select a SQL Server
page (see
“
Selecting a server that hosts SQL Server
” on page 18).
Selecting a server that hosts SQL Server
Use the Select a SQL Server page to select one of the servers that hosts SQL Server discovered on
your domain by the wizard.
1.
Do one of the following:
•
Enter the host name of a server that hosts SQL (exactly as it is registered in the domain).
•
Enter the IP address of a server that hosts SQL.
2.
Click
Next
to open the
Select Database Components
page (see
“
Selecting SQL Server database components
” on page 18).
Selecting SQL Server database components
Use the
Select Database Components
page to select the SQL Server database and database components
you want to host on your HP Storage Server.
1.
Do one of the following:
•
Select all components (including all of its components) by checking the box next to the
component.
•
Select individual database components by expanding the list and checking the boxes next to
the components.
You must select all the database components, including the log file, in a database if you want
to run backups and/or take snapshots of the database using ASM.
NOTE:
ASM cannot migrate system databases; for example, ASM cannot migrate
master
,
model
,
msdb
and
tempdb
.
The following table lists the action ASM can perform for each database component listed.
Table 4 Selecting database components to host
Description
Action
Component's check box is not selected, so ASM will not perform any
action. Select check box to change action.
None
Storage space will be allocated and configured on your HP Storage
Server. Component's data will be migrated to your HP Storage Server.
Allocate Space, Move Data
Component's data is already hosted on your HP Storage Server and
already managed by ASM. No action is possible.
None, Already Managed
Hosting storage for applications and shared folders
18