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

HP AiO400t HP StorageWorks All-in-One Storage System User Guide (440583-005, F - Page 65

Using the Host a SQL Server Database Wizard, Selecting a server that hosts SQL Server

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

Page 65 highlights

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

Section	Page
All-in-One Storage System	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	23
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
SAS and SATA hard drive LEDs	43
3 Storage management overview	45
Storage management elements	45
Storage process management example	45
Physical storage elements	46
Arrays	47
Fault tolerance	48
Online Spares	48
Logical storage elements	48
Logical drives (LUNs)	48
Partitions	49
Volumes	49
File system elements	50
File sharing elements	50
Volume Shadow Copy Service overview	50
Using storage elements	51
Network adapter teaming	51
Management tools	51
HP Systems Insight Manager	51
Management Agents	51
All-in-One Storage Manager	52
Software requirements	52
Software support	52
Storage management infrastructure	53
Managing storage for application servers	53
Managing storage for shared folders	54
About the user interface	56
Menu bar	56
Toolbar	56
Navigation pane	56
Content pane	56
Actions pane	57
Defining user interface options	58
Add an All-in-One Storage System	59
Remove an All-in-One Storage System	59
4 Hosting storage for applications and shared folders	61
Using the Host an Exchange Storage Group Wizard	62
Entering a name of a server that hosts Exchange	62
Selecting Exchange storage group components	63
Local Continuous Replication (LCR)	63
Using the Create a Shared Folder Wizard	64
Naming a shared folder	64
Setting permissions for a shared folder	64
Using the Host a SQL Server Database Wizard	65
Selecting a server that hosts SQL Server	65
Selecting SQL Server database components	65
Selecting a database workload type	66
Using the Host a User-Defined Application Wizard	67
Choose type of application	68
Entering an application name	68
Using the Create a Virtual Library Wizard	68
Accessing the Virtual Library Wizard	68
Configure your virtual library	68
Allocating space for components	69
Selecting advanced configuration settings	71
Selecting data protection	76
Reviewing task summary and scheduling tasks	78
Monitoring task completion status	79
Cancelling tasks	79
Migrating user-defined application data from a remote application	80
5 Data protection	81
Data Protection Window	81
Selecting local or alternate backup	81
Managing snapshots and backups	82
Snapshots	82
Scheduling snapshots	82
Taking snapshots	82
Exposing a snapshot	83
Unexposing a snapshot	83
Reverting data to snapshots	83
Scheduling and running backups	84
Managing backups	84
Restoring data from backups	84
Selecting the restore destination	85
Launching DPX	85
Using DPX to restore data	85
Setting the password for the ASMbackup user account	85
To specify a password	86
Using the Administrators' account to change the ASMbackup password	86
Installing Data Protector Express on other devices	86
6 Managing storage	89
Increasing or reducing the allocated storage	89
Changing the percent full warning threshold	90
Removing application areas from view	91
Changing permissions, names, descriptions, or paths of shared folders	91
Deleting shared folders	92
7 Monitoring storage	93
Application View	93
Accessing application and shared folder properties	94
Data Protection	103
Storage View	105
Accessing storage area properties	106
Application Server View	108
Accessing application server properties	108
Storage Utilization View	110
8 Troubleshooting, servicing, and maintenance	111
Troubleshooting the storage system	111
Operating system problems and resolutions	111
Application software problems	112
SQL Server errors	112
ASM alerts	112
Recovering from logical disk failure	117
Maintenance updates	117
System updates	117
Troubleshooting resources	117
HP web site	117
Storage system documentation	118
Subscriber's Choice	118
White papers	118
Firmware updates	118
WEBES (Web Based Enterprise Services)	118
Certificate of Authenticity	119
9 System recovery	121
The System Recovery DVD	121
To restore a factory image	121
Systems with a DON'T ERASE partition	121
Managing disks after a restoration	121
A File server management	123
New or improved file services features in Windows Storage Server 2003 R2	123
Storage Manager for SANs	123
Single Instance Storage	123
Search enhancements	124
File Server Resource Manager	124
Windows SharePoint Services	124
HP All-in-One Management Console	124
File services management	125
Configurable and pre-configured storage	125
Storage management utilities	126
Array management utilities	126
Array Configuration Utility	126
Disk Management utility	127
Guidelines for managing disks and volumes	127
When managing disks and volumes:	127
Scheduling defragmentation	128
Disk quotas	128
Adding storage	129
Expanding storage	129
Extending storage using Windows Storage Utilities	130
Extend volumes using Disk Management	130
Expanding storage using the Array Configuration Utility	130
Expand logical drive	130
Volume shadow copies	131
Shadow copy planning	131
Identifying the volume	131
Allocating disk space	132
Identifying the storage area	133
Determining creation frequency	133
Shadow copies and drive defragmentation	133
Mounted drives	134
Managing shadow copies	134
The shadow copy cache file	134
Enabling and creating shadow copies	136
Viewing a list of shadow copies	136
Set schedules	136
Viewing shadow copy properties	137
Redirecting shadow copies to an alternate volume	137
Disabling shadow copies	138
Managing shadow copies from the storage system desktop	138
Shadow Copies for Shared Folders	139
SMB shadow copies	140
NFS shadow copies	141
Recovery of files or folders	141
Recovering a deleted file or folder	141
Recovering an overwritten or corrupted file	142
Recovering a folder	142
Backup and shadow copies	143
Shadow Copy Transport	143
Folder and share management	144
Folder management	144
Share management	150
Share considerations	150
Defining Access Control Lists	151
Integrating local file system security into Windows domain environments	151
Comparing administrative (hidden) and standard shares	151
Managing shares	152
File Server Resource Manager	152
Quota management	152
File screening management	152
Storage reports	153
Other Windows disk and data management tools	153
Additional information and references for file services	153
Backup	153
HP StorageWorks Library and Tape Tools	153
Antivirus	153
Security	154
More information	154
B Print services	155
Microsoft Print Management Console	155
New or improved HP print server features	155
HP Web Jetadmin	155
HP Install Network Printer Wizard	155
HP Download Manager for Jetdirect Print Devices	155
Microsoft Print Migrator Utility	155
Network printer drivers	156
Print services management	156
Microsoft Print Management Console	156
HP Web Jetadmin installation	156
Web-based printer management and Internet printing	156
Planning considerations for print services	157
Print queue creation	157
Sustaining print administration tasks	158
Driver updates	158
Print drivers	158
User-mode vs. kernel-mode drivers	158
Kernel-mode driver installation blocked by default	158
HP Jetdirect firmware	158
Printer server scalability and sizing	159
Backup	159
Best practices	159
Troubleshooting	160
Additional references for print services	160
C Microsoft Services for Network File System (MSNFS)	161
MSNFS Features	161
UNIX Identity Management	161
MSNFS use scenarios	162
MSNFS components	162
Administering MSNFS	163
Server for NFS	163
Server for NFS Authentication DLL vs. Service for User for Active Directory domain controllers	163
Installing NFS Authentication DLL on domain controllers	164
Elevate S4U2 functionality on Windows Server 2003 domain controllers	165
Server for NFS administration	165
Accessing NFS resources for Windows users and groups	166
Managing access using the .maphosts file	166
Allowing anonymous access to resources by NFS clients	166
Best practices for running Server for NFS	167
User Name Mapping	168
User Name Mapping Administration	169
Best practices for User Name Mapping	169
Microsoft Services for NFS troubleshooting	169
Microsoft Services for NFS command-line tools	169
Optimizing Server for NFS performance	170
Print services for UNIX	170
Point and print from UNIX to Windows Server 2003	171
Additional resources	171
D Other network file and print services	173
File and Print Services for NetWare (FPNW)	173
Installing Services for NetWare	173
Managing File and Print Services for NetWare	174
Creating and managing NetWare users	175
Adding local NetWare users	176
Enabling local NetWare user accounts	176
Managing NCP volumes (shares)	177
Creating a new NCP share	178
Modifying NCP share properties	178
Print Services for NetWare	178
Point and Print from Novell to Windows Server 2003	178
Additional resources	179
AppleTalk and file services for Macintosh	179
Installing the AppleTalk protocol	179
Installing File Services for Macintosh	179
Completing setup of AppleTalk protocol and shares	179
Print services for Macintosh	180
Installing Print Services for Macintosh	180
Point and Print from Macintosh to Windows Server 2003	180
E Configuring storage system for Web access (optional)	181
Setting up an Internet connection	181
F Regulatory compliance and safety	183
Federal Communications Commission notice	183
Class A equipment	183
Class B equipment	183
Declaration of conformity for products marked with the FCC logo, United States only	184
Modifications	184
Cables	184
Laser compliance	184
International notices and statements	185
Canadian notice (Avis Canadien)	185
Class A equipment	185
Class B equipment	185
European Union notice	185
BSMI notice	186
Japanese notice	186
Korean notice A&B	186
Class A equipment	186
Class B equipment	186
Safety	187
Battery replacement notice	187
Taiwan battery recycling notice	187
Power cords	187
Japanese power cord notice	188
Electrostatic discharge	188
Preventing electrostatic discharge	188
Grounding methods	188
Waste Electrical and Electronic Equipment (WEEE) directive	188
Czechoslovakian notice	188
Danish notice	189
Dutch notice	189
English notice	189
Estonian notice	190
Finnish notice	190
French notice	190
German notice	190
Greek notice	191
Hungarian notice	191
Italian notice	191
Latvian notice	191
Lithuanian notice	192
Polish notice	192
Portuguese notice	192
Slovakian notice	193
Slovenian notice	193
Spanish notice	193
Swedish notice	193
Glossary	195