HP STORAGEWORKS ALL-IN-ONE STORAGE SYSTEM, User Manual

Page: 65 / 204

2. Click Next to open the Storage Allocation page (see
“ Allocating space for components ” on page 69).
Using the Host a SQL Server Database Wizard
The Host a SQL Server Database Wizard automatically discovers the servers that host SQL Server
and SQL Server databases on your domain, and helps you allocate and configure storage space for
each database component you select:
• Data file—Contains pointers to database files, storage for system tables and objects, and storage
for database data and objects.
• Log file—Holds all the transaction log information for the database. Every database has exactly
one log file, which cannot be used to hold any other data.
Before you begin configuring storage for SQL Server
• Make sure the ASM agent is installed on each server with SQL Server data you plan to host. See
“
Installing the All-in-One Storage Manager Agent on network application servers ” on page 33 for
more information.
• Make sure you have a current backup of your SQL Server data and logs.
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 65).
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 65).
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.
All-in-One Storage System 65