Selecting a server that hosts sql server, Selecting sql server database components, 23 selecting sql server database components – HP StorageWorks All-in-One SB600c Storage Blade User Manual
Page 23: Selecting database components to host
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
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
Use the Select Database Components page to select the SQL Server database and database
components you want to host on your HP All-in-One Storage System.
1.
Do one of the following:
• Select the entire database 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 5 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
Component's data is already hosted on your HP All-in-One Storage
System. The component was removed from view. The component will
be returned to view. See “
Removing application areas from
” on page 42 for more information.
Allocate Space
Storage space will be allocated and configured on your HP All-in-One
Storage System. Component's data will be migrated to your HP All-in-One
Storage System.
Allocate Space, Move Data
Component's data is already hosted on your HP All-in-One Storage
System and already managed by ASM. No action is possible.
None, Already Managed
All-in-One Storage Manager
23