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

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

SQL Server database - SQL Server database Displays the following SQL Server, SQL Server

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

Page 108 highlights

properties window, and in parenthesis, which applications are applicable: SQL Server, SQL Server databases or SQL Server database components. • General tab-(SQL Server, SQL Server database, SQL Server database component) Displays the name of the application, the total capacity reserved for the application, and its operating status: Table 31 Operating status: SQL Server properties Status indicator OK Warning Critical Value SQL Server is running and storage is online. No alerts. See the Alerts list for more information. See the Alerts list for more information. • Details tab - (SQL Server database) - (SQL Server database) Displays the following SQL Server values: Table 32 Details tab: SQL Server database properties Property SQL Server SQL server status Version Database status Workload type Clustered Value Name of server where SQL Server storage is being hosted. Operational status of the SQL Server. Version of SQL Server. Operational status of the SQL Server database. Workload type of the SQL Server database. Indicates whether the server that hosts SQL Server is part of a cluster. • Snapshots tab - (SQL Server database) Allows you to schedule snapshots of the database. For more information, see "Scheduling and running snapshots" on page 87. • Backup tab - (SQL Server database) Allows you to schedule backups of the database. See "Scheduling backups" on page 90 for more information. • Replication tab - (SQL Server database) Allows you to configure data replication of the database. See "Running replication" on page 93 for more information. • Storage tab-(SQL Server database component) Displays the database component's storage space, including allocated space, used space, free space, and the following storage allocation details: Table 33 Storage tab: SQL Server database component properties Property Application Path Protocol Application Server Host Name Value Path to the file directory on the server that hosts SQL Server where the database component's data is saved by SQL Server. The file directory is located on the volume created on the iSCSI LUN exported by ASM to the server that hosts SQL Server. Communication protocol used to transfer data between the server that hosts SQL Server (and the database component) and your HP All-in-One Storage System. Name of server that hosts SQL Server and the database component. 108 Monitoring storage

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

Match case Limit results 1 per page

properties window, and in parenthesis, which applications are applicable: SQL Server, SQL Server

databases or SQL Server database components.

•

General tab

—(SQL Server, SQL Server database, SQL Server database component) Displays the

name of the application, the total capacity reserved for the application, and its operating status:

Table 31 Operating status: SQL Server properties

Value

Status indicator

SQL Server is running and storage is online. No alerts.

See the Alerts list for more information.

Warning

See the Alerts list for more information.

Critical

•

Details tab

— (SQL Server database) — (SQL Server database) Displays the following SQL Server

values:

Table 32 Details tab: SQL Server database properties

Value

Property

Name of server where SQL Server storage is being hosted.

SQL Server

Operational status of the SQL Server.

SQL server status

Version of SQL Server.

Version

Operational status of the SQL Server database.

Database status

Workload type of the SQL Server database.

Workload type

Indicates whether the server that hosts SQL Server is part of a cluster.

Clustered

•

Snapshots tab

— (SQL Server database) Allows you to schedule snapshots of the database. For

more information, see “

Scheduling and running snapshots

” on page 87.

•

Backup tab

— (SQL Server database) Allows you to schedule backups of the database. See

“

Scheduling backups

” on page 90 for more information.

•

Replication tab

— (SQL Server database) Allows you to configure data replication of the database.

See “

Running replication

” on page 93 for more information.

•

Storage tab

—(SQL Server database component) Displays the database component's storage

space, including allocated space, used space, free space, and the following storage allocation

details:

Table 33 Storage tab: SQL Server database component properties

Value

Property

Path to the file directory on the server that hosts SQL Server where the

database component's data is saved by SQL Server. The file directory is

located on the volume created on the iSCSI LUN exported by ASM to the

server that hosts SQL Server.

Application Path

Communication protocol used to transfer data between the server that

hosts SQL Server (and the database component) and your HP All-in-One

Storage System.

Protocol

Name of server that hosts SQL Server and the database component.

Application Server Host Name

Monitoring storage

108