Selecting a database workload type, Selecting database components to host – HP StoreEasy 1000 Storage User Manual

Page 21

Advertising
background image

1.

Do one of the following:

• Select all components (including all of its components) by checking the box next to the com-

ponent.

• 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
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

” on page 55 and

Log file properties for database

” on page 55 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

” on page 21).

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.

HP StorageWorks Automated Storage Manager User Guide

21

Advertising
This manual is related to the following products: