Home » HP Manuals » Storage Devices » HP AiO400r » Manual Viewer

HP AiO400r HP StorageWorks All-in-One Storage System User Guide (440583-006, J - Page 72

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

Add to My Manuals
Save this manual to your list of manuals

Page 72 highlights

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 72). 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 72). 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. 72 Hosting storage for applications and shared folders

Section	Page
HP StorageWorks All-in-One Storage System User Guide	1
Table of Contents	3
About this guide	15
Intended audience	15
Related documentation	15
Document conventions and symbols	15
Rack stability	16
HP technical support	17
Customer self repair	17
Product warranties	17
Subscription service	17
HP websites	18
Documentation feedback	18
1 Installing and configuring the server	19
Setup overview	19
Planning for installation	19
Planning a network configuration	20
Configuration checklist	20
Installing the server	21
Locating and writing down the serial number	21
Checking kit contents	21
Powering on the server	22
Factory image	22
Physical configuration	22
Default boot sequence	23
Accessing the All-in-One Management Console	23
Using the direct attach method	24
Using the remote browser method	24
Using the Remote Desktop method	26
Logging off and disconnecting	27
Telnet Server	27
Enabling Telnet Server	27
Sessions information	27
Using remote management methods	28
Using the Lights-Out 100 method	28
Using the Integrated Lights-Out 2 method	29
Configuring the server on the network	30
Before you begin	30
Running the Rapid Startup Wizard	32
Completing system configuration	32
Installing the All-in-One Storage Manager Agent	33
Installing the All-in-One Storage Manager Agent on network application servers	33
2 Storage system components	35
HP StorageWorks 400r All-in-One Storage System	35
HP StorageWorks 400t All-in-One Storage System	37
HP StorageWorks 600 All-in-One Storage System	40
HP StorageWorks 1200r All-in-One Storage System	43
SAS and SATA hard drive LEDs	45
3 Storage management overview	49
Storage management elements	49
Storage process management example	49
Physical storage elements	50
Arrays	51
Fault tolerance	52
Online Spares	52
Logical storage elements	52
Logical drives (LUNs)	52
Partitions	53
Volumes	53
File system elements	54
File sharing elements	54
Volume Shadow Copy Service overview	54
Using storage elements	55
Network adapter teaming	55
Management tools	55
HP Systems Insight Manager	55
Management Agents	55
4 All-in-One Storage Manager	57
Software requirements	57
Software support	57
Storage management infrastructure	58
Managing storage for application servers	58
Managing storage for shared folders	59
About the user interface	61
Menu bar	61
Toolbar	61
Navigation pane	61
Content pane	62
Actions pane	62
Add an All-in-One Storage System	64
Remove an All-in-One Storage System	64
Configuring display options	64
Configure Application Credentials	65
Configure Storage Networks	65
Resetting iSCSI connections	66
5 Hosting storage for applications and shared folders	67
Using the Host an Exchange Storage Group Wizard	68
Entering a name of a server that hosts Exchange	68
Selecting Exchange storage group components	69
Local Continuous Replication (LCR)	69
Using the Create a Shared Folder Wizard	70
Choosing shared folder types	70
Naming a shared folder	70
Setting permissions for a shared folder	71
Using the Host a SQL Server Database Wizard	71
Selecting a server that hosts SQL Server	72
Selecting SQL Server database components	72
Selecting a database workload type	73
Using the Host a User-Defined Application Wizard	74
Choose type of application	74
Entering an application name	75
Using the Create a Virtual Library Wizard	75
Accessing the Virtual Library Wizard	75
Configure your virtual library	75
Allocating space for components	76
Setting advanced storage properties	77
Selecting data protection	81
Reviewing task summary and scheduling tasks	84
Monitoring task completion status	85
Cancelling tasks	86
Migrating user-defined application data from a remote application	86
6 Managing data protection	87
Scheduling and running snapshots	87
Managing snapshots	88
Taking and deleting snapshots	88
Exposing a snapshot	88
Unexposing a snapshot	89
Reverting data to snapshots	89
Scheduling backups	90
Managing backups	90
Running a device backup	90
Running a virtual library backup	91
Restoring data from backups	91
Using DPX to restore data	91
Setting the password for the ASMbackup user account	92
Using the Administrator account to change the ASMbackup password	92
Installing Data Protector Express on other machines	93
Running replication	93
Pausing and resuming replication	94
7 Managing storage	97
Increasing or reducing the allocated storage	97
Changing the percent full warning threshold	98
Removing application areas from view	98
Changing permissions, names, descriptions, or paths of shared folders	99
Deleting shared folders	99
8 Monitoring storage	101
Application View	101
Accessing application and shared folder properties	102
Storage View	114
Accessing storage area properties	115
Application Server View	117
Accessing application server properties	117
Storage Utilization View	119
All-in-One Storage Manager Alerts	119
9 Troubleshooting, servicing, and maintenance	121
Troubleshooting the storage system	121
Operating system problems and resolutions	121
Application software problems	122
ASM alerts	122
Recovering from logical disk failure	130
Maintenance updates	131
System updates	131
Troubleshooting resources	131
HP web site	131
Storage system documentation	131
Subscriber's Choice	131
White papers	131
Firmware updates	132
WEBES (Web Based Enterprise Services)	132
Certificate of Authenticity	132
10 System recovery	133
The System Recovery DVD	133
To restore a factory image	133
Systems with a DON'T ERASE partition	133
Managing disks after a restoration	133
A File server management	135
New or improved file services features in Windows Storage Server 2003 R2	135
Storage Manager for SANs	135
Single Instance Storage	135
Search enhancements	136
File Server Resource Manager	136
Windows SharePoint Services	136
HP All-in-One Management Console	136
File services management	137
Configurable and pre-configured storage	137
Storage management utilities	138
Array management utilities	138
Array Configuration Utility	138
Disk Management utility	139
Guidelines for managing disks and volumes	139
When managing disks and volumes:	139
Scheduling defragmentation	140
Disk quotas	140
Adding storage	141
Expanding storage	141
Extending storage using Windows Storage Utilities	142
Extend volumes using Disk Management	142
Expanding storage using the Array Configuration Utility	142
Expand logical drive	142
Volume shadow copies	143
Shadow copy planning	143
Identifying the volume	143
Allocating disk space	144
Identifying the storage area	145
Determining creation frequency	145
Shadow copies and drive defragmentation	145
Mounted drives	146
Managing shadow copies	146
The shadow copy cache file	146
Enabling and creating shadow copies	148
Viewing a list of shadow copies	148
Set schedules	148
Viewing shadow copy properties	149
Redirecting shadow copies to an alternate volume	149
Disabling shadow copies	150
Managing shadow copies from the storage system desktop	150
Shadow Copies for Shared Folders	151
SMB shadow copies	152
NFS shadow copies	153
Recovery of files or folders	153
Recovering a deleted file or folder	153
Recovering an overwritten or corrupted file	154
Recovering a folder	154
Backup and shadow copies	155
Shadow Copy Transport	155
Folder and share management	156
Folder management	156
Share management	162
Share considerations	162
Defining Access Control Lists	163
Integrating local file system security into Windows domain environments	163
Comparing administrative (hidden) and standard shares	163
Managing shares	164
File Server Resource Manager	164
Quota management	164
File screening management	164
Storage reports	165
Other Windows disk and data management tools	165
Additional information and references for file services	165
Backup	165
HP StorageWorks Library and Tape Tools	165
Antivirus	165
Security	166
More information	166
B Print services	167
Microsoft Print Management Console	167
New or improved HP print server features	167
HP Web Jetadmin	167
HP Install Network Printer Wizard	167
HP Download Manager for Jetdirect Print Devices	167
Microsoft Print Migrator Utility	167
Network printer drivers	168
Print services management	168
Microsoft Print Management Console	168
HP Web Jetadmin installation	168
Web-based printer management and Internet printing	168
Planning considerations for print services	169
Print queue creation	169
Sustaining print administration tasks	170
Driver updates	170
Print drivers	170
User-mode vs. kernel-mode drivers	170
Kernel-mode driver installation blocked by default	170
HP Jetdirect firmware	170
Printer server scalability and sizing	171
Backup	171
Best practices	171
Troubleshooting	172
Additional references for print services	172
C Microsoft Services for Network File System (MSNFS)	173
MSNFS Features	173
UNIX Identity Management	173
MSNFS use scenarios	174
MSNFS components	174
Administering MSNFS	175
Server for NFS	175
Server for NFS Authentication DLL vs. Service for User for Active Directory domain controllers	175
Installing NFS Authentication DLL on domain controllers	176
Elevate S4U2 functionality on Windows Server 2003 domain controllers	177
Server for NFS administration	177
Accessing NFS resources for Windows users and groups	178
Managing access using the .maphosts file	178
Allowing anonymous access to resources by NFS clients	178
Best practices for running Server for NFS	179
User Name Mapping	180
User Name Mapping Administration	181
Best practices for User Name Mapping	181
Microsoft Services for NFS troubleshooting	181
Microsoft Services for NFS command-line tools	181
Optimizing Server for NFS performance	182
Print services for UNIX	182
Point and print from UNIX to Windows Server 2003	183
Additional resources	183
D Other network file and print services	185
File and Print Services for NetWare (FPNW)	185
Installing Services for NetWare	185
Managing File and Print Services for NetWare	185
Creating and managing NetWare users	187
Adding local NetWare users	188
Enabling local NetWare user accounts	188
Managing NCP volumes (shares)	189
Creating a new NCP share	190
Modifying NCP share properties	190
Print Services for NetWare	190
Point and Print from Novell to Windows Server 2003	190
Additional resources	191
AppleTalk and file services for Macintosh	191
Installing the AppleTalk protocol	191
Installing File Services for Macintosh	191
Completing setup of AppleTalk protocol and shares	191
Print services for Macintosh	192
Installing Print Services for Macintosh	192
Point and Print from Macintosh to Windows Server 2003	192
E Configuring storage system for Web access (optional)	193
Setting up an Internet connection	193
F Regulatory compliance and safety	195
Federal Communications Commission notice	195
Class A equipment	195
Class B equipment	195
Declaration of conformity for products marked with the FCC logo, United States only	196
Modifications	196
Cables	196
Laser compliance	196
International notices and statements	197
Canadian notice (Avis Canadien)	197
Class A equipment	197
Class B equipment	197
European Union notice	197
BSMI notice	198
Japanese notice	198
Korean notice A&B	198
Class A equipment	198
Class B equipment	198
Safety	199
Battery replacement notice	199
Taiwan battery recycling notice	199
Power cords	199
Japanese power cord notice	200
Electrostatic discharge	200
Preventing electrostatic discharge	200
Grounding methods	200
Waste Electrical and Electronic Equipment (WEEE) directive	200
Czechoslovakian notice	200
Danish notice	201
Dutch notice	201
English notice	201
Estonian notice	202
Finnish notice	202
French notice	202
German notice	202
Greek notice	203
Hungarian notice	203
Italian notice	203
Latvian notice	203
Lithuanian notice	204
Polish notice	204
Portuguese notice	204
Slovakian notice	205
Slovenian notice	205
Spanish notice	205
Swedish notice	205
Glossary	207