HP X1800sb User Manual download pdf (Page 15)

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

DescriptionAction

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 System.

Component's data will be migrated to your HP Storage System.

Allocate Space, Move Data

Component's data is already hosted on your HP Storage System and already

managed by ASM. No action is possible.

None, Already Managed

2. To view the properties for a database component, select the database component name and

then click Properties.

See Data file properties and Log file properties for database for descriptions of the properties

displayed.

3. If you do not want ASM to delete the original files for the selected database components from

the server that hosts SQL Server after it migrates the data to your HP Storage System, clear

the Delete original files after successful migration checkbox.

4. When you are done, click Next to open the Select the Database Workload Type page (see

“Selecting a database workload type” (page 15)).

Selecting a database workload type

Use the Select the Database Workload Type page to select the workload type for the SQL Server

database.

NOTE: You can only select the database workload type while using the Host a SQL Server

Database Wizard. The database workload type cannot be changed later.

1. Do one of the following:

• Select Transaction processing (TP) for frequently updated, fast growing databases with

large volumes of data requiring concurrent user access.

• Select Decision support systems (DSS) for databases designed to handle queries on large

amounts of data, typically used for data-mining applications.

2. When you are done, click Next to open the Storage Allocation page (see “Allocating space

for components” (page 17)).

Using the Host a User-Defined Application Wizard

This wizard helps you set up your HP Storage System to store application data for various

applications. Storage is allocated for the application, optionally exposed to another server using

the iSCSI protocol, and an NTFS file volume may be optionally created on the remote application

Using the Host a User-Defined Application Wizard 15

1 2 ... 10 11 12 13 14 15 16 17 18 19 20 ... 54 55

Comments to this Manuals

No comments

HP X1800sb User Manual Page 15

Comments to this Manuals

Related products and manuals for Database software HP X1800sb