HP StorageWorks All-in-One Storage Manager user guide 452695 001 Part number: 452695–001 First edition: September 2007
Legal and notice information © Copyright 2006-2007 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice.
Contents About this guide ................................................................................... 7 Intended audience ...................................................................................................................... Prerequisites ............................................................................................................................... Related documentation ...................................................................................................
3 Configuring data protection ............................................................... 37 Scheduling and running backups ................................................................................................ 37 Scheduling, taking, and deleting snapshots .................................................................................. 38 Exposing and unexposing a snapshot ......................................................................................... 38 4 Managing storage .......
Figures 1..Application storage infrastructure .............................................................................. 13 2..Shared folder storage infrastructure ...........................................................................
Tables 1..Document conventions ............................................................................................... 8 2..Software support .................................................................................................... 11 3..Actions pane quick reference ................................................................................... 15 4..Selecting storage group components to host ............................................................... 21 5..
About this guide This guide provides information about the HP StorageWorks All-in-One Storage Manager (ASM) software, including how to use the ASM storage-allocation wizards and user interface to: • Host SQL Server, Exchange, and user-defined application data on your HP All-in-One Storage System. • Create shared folders on your HP All-in-One Storage System. • Manage and monitor storage on your HP All-in-One Storage System. • Backup and take snapshots of data stored on your HP All-in-One Storage System.
the HP StorageWorks All-in-One Storage System Recovery DVD. See the HP StorageWorks All-in-One Storage System quick start instructions for more information.
Using online help The ASM help system incorporates the following navigational features: • Contents tab—Displays a table of contents (TOC) for the help system. Topics are organized in books for efficient retrieval. Click the icon located next to each folder to expand the outline and display topics. To view a topic, click a topic. • Index tab—Displays an index of help topics. To locate a topic, either scroll through the list, or enter a keyword or phrase for which to search and then press Enter.
About this guide
1 Overview HP StorageWorks All-in-One Storage Manager (ASM) is a storage hosting and management tool that radically simplifies: • • • • Hosting storage for applications and shared folders, page 19 Configuring data protection, page 37 Managing storage, page 41 Monitoring storage, page 47 ASM provides storage-allocation wizards that walk you through the process of allocating and configuring storage on your HP All-in-One Storage System to host application data and shared folders.
Microsoft SQL Server 2000 and 2005 See “Using the Host a SQL Server Database Wizard” on page 22. User-defined applications See “Using the Host a User-Defined Application Wizard” on page 24. Microsoft iSCSI Target and Data Protector Express are required to host application storage and create backups using ASM. Microsoft iSCSI Target and Data Protector Express comes preinstalled on your HP All-in-One Storage System. A license key is not required for Microsoft iSCSI Target.
Figure 1 Application storage infrastructure NOTE: The iSCSI communication path is transparent to the application, application server, and Windows Explorer. The application, application server, and Windows Explorer believe the data is stored on the application server. So, to view the application data, you must navigate to the iSCSI LUN(s) on the application server, not the LUN(s) on your HP All-in-One Storage System, using Windows Explorer. ASM provides automated data migration for Exchange and SQL Server.
Figure 2 Shared folder storage infrastructure ASM discovers any top-level and nested shared folders on your HP All-in-One Storage System during setup and afterwards on an ongoing basis. ASM allows you to monitor and manage any top-level shared folders created on your HP All-in-One Storage System using ASM or other applications, such as Windows Explorer or the Shared Folder MMC snap-in.
Toolbar The toolbar, located just below the menu bar in the ASM main window, is the MMC toolbar. See the MMC online help for more information. To open MMC online help, click Help in the Actions pane. Navigation pane The Navigation pane, located on the left side of the ASM main window, allows you to quickly navigate between HP All-in-One Storage Management applications.
Menu Description Storage Utilization View Displays the allocated storage values for specific applications and the shared folders pool, the unallocated storage value, and the storage value for data not managed by ASM in a pie chart. See “Storage Utilization View” on page 61 for more information. Tools > Task Viewer Opens the Task Viewer, where you can view the: • Status of tasks completed or scheduled to run in the future. • All tasks that failed and the errors reported.
Menu Description folder properties” on page 48, “Accessing storage area properties” on page 57, and “Accessing application server properties” on page 60 for more information.* Data Protection Opens the Data Protection tab of the Properties window where you can schedule backups, run a backup, or restore data from a backup. You can also schedule snapshots, take a snapshot, expose a snapshot, or revert data to a past snapshot. See “Configuring data protection” on page 37 for more information.
Overview
2 Hosting storage for applications and shared folders The All-in-One Storage Manager (ASM) radically simplifies hosting application storage and shared folders on your HP All-in-One Storage System, using storage-allocation wizards. Use storage-allocation wizards to allocate and configure storage for these applications: Application Description For more information Exchange Allocate and configure storage for individual Exchange storage group components.
Using the Host an Exchange Storage Group Wizard The Host an Exchange Storage Group Wizard automatically discovers the Exchange storage groups in your network domain and helps you allocate and configure storage space for these components: • Mail stores—Contain the data in user mailboxes. • Public stores—Contain the data in public folders. • Logs—Provide a record of every message stored in a storage group.
The table below lists the action ASM will perform for each storage group component selected. Table 4 Selecting storage group components to host 2. Action Description None Component's check box is not selected, so ASM will not perform any action. Select check box to change action. Allocate Space Component's data is already hosted on your HP All-in-One Storage System. The component was removed from view. The component will be returned to view.
Naming a shared folder Use the Enter a Shared Folder Name and Description page to provide ASM with a name and description for the shared folder. 1. Enter the name for the shared folder. NOTE: The path to the shared folder is created by ASM and is based on the shared folder name. The Share Path field is Read Only. 2. Enter a description of the shared folder (optional). 3. Click Next to open the Set Shared Folder Permissions page (see Setting permissions for a shared folder).
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). 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. 2. 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. To view the properties for a database component, select the database component name and then click Properties. See “Data file properties” on page 54 and “Log file properties for database” on page 54 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 All-in-One Storage System, clear the Delete original files after checkbox. 4.
NOTE: You need to know the path to the iSCSI LUN on the application server to configure the remote application to store data on the iSCSI LUN. The path to the iSCSI LUN is displayed on the application's Properties window on the Storage tab.
NOTE: The default allocated space size (15 MB) is the minimum value that can be allocated. You cannot set the size below the minimum value. NOTE: SQL Server and Exchange default advanced configuration settings are based on SQL Server or Exchange, and HP storage best practices, and should generally not be changed. 1. Do one of the following: • Click Next to accept the default values that ASM has provided for the components, user-defined application, or shared folder selected.
NOTE: After storage space is allocated and configured using a wizard, only the following storage configuration settings can be changed: • Allocated space size • Percent full warning threshold • Enforce Allocated Limit (shared folders only) The other advanced configuration settings cannot be changed due to the nature of how hard drives work. Once a logical disk is created, its configuration cannot be changed.
Item Description Notes RAID Level Hard drive formatting that provides different levels of performance, capacity, and data protection. For more information about RAID levels, see “Customizing RAID levels” on page 29.* RAID Stripe Size The number of bytes or kilobytes of data in each RAID stripe (block of data). The RAID stripe size selected affects performance. For the best performance, select the stripe size closest to the size of the files being saved.
Customizing RAID levels Before you customize the default RAID level setting, review Table 7 to see how the different RAID levels affect performance, capacity, and data protection level.
RAID level Description not interrupted. RAID 1+0(10) can withstand multiple simultaneous drive failures, as long as the failed drives are not mirrored to each other. RAID 5 – Distributed Data Guarding Offers the best combination of data protection and usable capacity while also improving performance over RAID 6. RAID 5 stores parity data across all the physical drives in the array and allows more simultaneous read operations and higher performance than data guarding.
If the capacity of the shared folder surpasses the percent full warning threshold and reaches the allocated space limit, the file folder status changes from Warning to Critical in the content pane, and users are blocked from adding data to this shared folder.
NOTE: Snapshots taken of a shared folder include all the other shared folders on the same volume, because snapshots are taken at the volume level. See “Storage View” on page 56, for information on viewing volumes. Selecting data protection is optional. To select data protection after storage is allocated, see “Configuring data protection” on page 37.
Any custom media rotation types you create in Data Protector Express are also listed in the Rotation Type drop-down menu. NOTE: Backups are performed on business days (Monday through Friday) at 11:00 p.m. by default. For information on changing the default schedule of the media rotation types, see Changing the default backup schedule.
Scheduling snapshots 1. Click the box on the right side of the Schedules box to open the Snapshot Schedule page. 2. Click Add to add a snapshot to the snapshot schedule. 3. Select a snapshot frequency (hourly, daily, weekly, monthly) for snapshots. 4. Enter a start date for snapshots. 5. Enter a start time for snapshots. 6. To add another snapshot to the snapshot schedule, repeat steps 2 through 5. 7. To delete a snapshot from the snapshot schedule, select the snapshot and click Remove. 8.
NOTE: Click the Expand tree icon next to a task to view its subtasks. Select a task to view its description in the Details box on the Task Viewer. The Task Viewer has a filter drop-down menu. Each selection displays information about task-completion status for different time periods: • Show All—Displays all tasks that have been completed or failed to complete. Displays the tasks and subtasks currently being processed and all scheduled tasks.
1. Using ASM, determine the path to the iSCSI LUN (logical disk) created on the application server by ASM, as follows: a. From the Filters drop-down menu, select User-Defined or All. b. Select the user-defined application in the content pane. c. In the Actions pane, select Properties. The Properties window opens. 2. d. Click the Storage tab. e. Record the Application Path information displayed. Copy the application data to the path on the application server recorded in step 1 as follows: a.
3 Configuring data protection Use the Data Protection tab on any Properties window to do the following: • Select a media rotation type for backups or run a backup of an Exchange storage group, SQL Server database, user-defined application, or shared folder. See “Scheduling and running backups” on page 37. • Create a snapshot schedule, take a snapshot, or delete a snapshot of an Exchange storage group, SQL Server database, user-defined application, or shared folder.
Scheduling, taking, and deleting snapshots 1. Do one of the following: 2. • Select an Exchange storage group (or a component of a storage group) in the content pane to schedule, take, or delete snapshots of the Exchange storage group. • Select an SQL Server database (or a component of the database) in the content pane to schedule, take, or delete snapshots of the SQL Server database.
c. Enter the expose path on the application server where you will view the snapshot. Using Windows Explorer, navigate to the expose path to view the snapshot. 4. To unexpose a snapshot: a. Select an exposed snapshot from the snapshot list. b. Click Unexpose. c. Click Yes to confirm.
Configuring data protection
4 Managing storage After an application is hosted or shared folder is created on your HP All-in-One Storage System using a storage-allocation wizard, you can manage its storage and data by: • • • • • • • • Increasing or reducing the allocated storage, page 41 Changing the percent full warning threshold, page 42 Removing application areas from view, page 42 Restoring application areas to view, page 43 Changing permissions, names, descriptions, or paths of shared folders, page 44 Deleting shared folders, pag
setting for an application component, the maximum value for Size Range is recalculated for each application component shown. NOTE: To change the percent full warning threshold and/or enforce allocated limit (shared folders only) setting, click Advanced. See “Selecting advanced configuration settings” on page 27 for more information. 4. Click Next to open the Review Tasks Summary page (see “Reviewing task summary and scheduling tasks” on page 34).
Removing an application component or user-defined application from view removes the application component selected in the content pane from view, which removes your ability to manage and monitor the application component or user-defined application's storage using ASM. Removing an application component or user-defined application from view does not unhost its storage. Its storage is still hosted on your HP All-in-One Storage System. NOTE: This action is not available for shared folders.
To be able once again to manage and monitor a user-defined application's storage using ASM, you must unhost the user-defined application's storage, use the Host a User-Defined Application Wizard to allocate new storage, manually migrate the application data to your HP All-in-One Storage System, and then configure the user-defined application to save its data to the newly allocated storage on your HP All-in-One Storage System.
3. • In the Action pane, click Properties and then select the Data Protection tab. Click Restore from backup to launch the wizard and open the Restore Source Device page (see Selecting the source device). Selecting the source device 1. Select the DVD-RW drive on your HP All-in-One Storage System, tape library, or virtual library where the backup is saved. 2. Click Next to open the Restore Destination page (see Selecting the restore destination). Selecting the restore destination 1.
5. Right-click the restore job and click Run to perform the restore. 6. Click Yes to confirm the restore. To view the status of the restore job, click Job Status in the Favorites pane. 7. Exit Data Protector Express. Reverting data to past snapshots ASM allows you to revert data stored on your HP All-in-One Storage System to a past snapshot. This overwrites the existing data and reverts it to a past state. NOTE: Snapshots of shared folders cannot be reverted to past snapshots using ASM.
5 Monitoring storage ASM provides storage-management functions so you can quickly view used and allocated storage, and percent full warning thresholds settings for application and shared folder storage on your HP All-in-One Storage System.
Accessing application and shared folder properties When Application View is selected in the Actions pane, you can view the storage status, alerts, and properties for the following: • • • • • Applications Application component User-defined applications Shared folders pool Shared folders Do one of the following: • Select the item in the content pane and then click Properties in the Actions pane. • Right-click the item in the content pane and select Properties.
• General tab—(Exchange, Exchange storage groups, and components) Displays the name of the application, the total capacity reserved for the application, and its operating status: Table 8 Operating status—Exchange properties Status indicator Value OK Exchange is running and storage is online. No alerts. Warning See the Alerts list for more information. See “Table 27” on page 64 for alert descriptions. Critical See the Alerts list for more information. See “Table 27” on page 64 for alert descriptions.
Property Value Application Server Volume Name Name of the volume on the server that hosts Exchange to which Exchange saves the storage group component's data. The volume resides on the iSCSI LUN exported by ASM to the server that hosts Exchange. Application Server Volume Status Status of the volume on the server that hosts Exchange where the storage group component is stored.
• Public Store tab—Displays the public store's free space and the following storage allocation details about the public store: Table 12 Public Store tab—Exchange storage group component properties Value Description Public Store Name Name of storage group public store. Online The storage group public store is available for use. Database File Path to the file that stores all messages submitted through MAPI, as well as the database tables that define mailboxes, messages, folders, and attachments.
Status indicator Value Warning The storage has surpassed the percent full warning threshold. See the Alerts list for more information. See “Table 27” on page 64 for alert descriptions. Critical Shared folder storage has past the allocated storage limit and alerts are shown. See the Alerts list for more information. See “Table 27” on page 64 for alert descriptions.
Accessing properties for SQL Server ASM provides properties information for SQL Server when SQL Server storage is hosted on your HP All-in-One Storage System. 1. In the Actions pane, select Application View. 2. From the Filters drop-down menu, select SQL Server or All. 3. Do one of the following: • Select one of the following:SQL Server, SQL Server database or a SQL Server database component in the content pane and then click Properties in the Actions pane.
Property Value Application Server Volume - Status Status of the volume on the server that hosts SQL Server where the database component is stored. Application Server Volume Exclusive Storage Indicates if database component storage is configured with exclusive storage. See “Table 6” on page 27 for more information. Application Server Volume - RAID Level The RAID level to which the database component storage is configured. See “Customizing RAID levels” on page 29 for more information.
• Data Protection tab—(SQL server database, SQL server database component) Allows you to schedule backups or run a backup of the database that owns the database component, or restore the database that owns the database component from a backup. It also allows you to schedule snapshots or take a snapshot of the database that owns the database component, expose a snapshot, or revert the database that owns the database component to a past snapshot.
Property Value Protocol Communication protocol used to transfer data between the server that hosts the user-defined application and your HP All-in-One Storage System. Application Server Host Name Name of server that hosts the user-defined application. Application Server Volume Name Name of the volume on the application server to which the user-defined application saves its data. The volume resides on the iSCSI LUN (logical disk) exported by ASM to the application server.
Storage area properties are displayed in order of hierarchy in an expandable and collapsible view. For example, all the volumes on your HP All-in-One Storage System are displayed under the logical disks they reside on, and all the applications and shared folders hosted on your HP All-in-One Storage System are displayed under the volumes on which they are stored. Application components and individual shared folders are displayed under the application or shared folders pool to which they belong.
• Select any logical disk in the content pane and then click Properties in the Actions pane. • Right-click any logical disk in the content pane and select Properties. Properties window ASM provides properties information for any logical disks and for any logical disk created on your HP All-in-One Storage System. General tab—Based on the application opened, logical disks or volumes, it will list the operating status for that application only.
Property Value Free Space Unused storage space on the logical disk that is not allocated. Table 24 Storage tab—HP All-in-One Storage System volume properties Property Value Storage Server Host Name Name of your HP All-in-One Storage System. Storage Server Volume - Name Name of the volume on your HP All-in-One Storage System. Storage Server Volume - Status Status of the volume on your HP All-in-One Storage System.
Click the Expand tree icon next to each application server to view the used and allocated storage properties for the volume and application components. Click the Collapse tree icon next to an expanded application server to hide the volume and application component storage properties. To view all the storage properties for an item listed in the content pane, see Accessing application server properties.
• Storage tab—Displays the unallocated space, used space, free space on the volume, and the following storage allocation details: Table 26 Storage tab—Application server volume properties Property Value Application Server Host Name Name of the application server where the volume resides. Application Server Volume Name Name of the volume on the application server. Volume is located on the iSCSI LUN exported by ASM. Application Server Volume Status Status of the volume on the application server.
The unmanaged value is the total storage being used to store data not managed by ASM, such as application or shared folder data no longer managed by ASM because the application components or shared folder was removed from view (see “Removing application areas from view” on page 42) and any other data saved on your HP All-in-One Storage System that is not managed by ASM. • Unallocated—Unused storage that is not allocated.
6 Troubleshooting This chapter describes and provides solutions to: • SQL Server errors, page 63 • ASM alerts, page 64 Application software problems If your application software locks up, perform the following actions: • • • • • Check the application log and operating system log for entries indicating why the software failed. Check for incompatibility with other software on the server. Check the support web site of the software vendor for known problems.
ASM alerts ASM generates an alert whenever the status of an application area or storage area changes from OK to Warning or Critical. The alerts describe the condition that caused the storage status to change. Alerts are displayed on the General tab of the Properties window. To view alerts: • Select an item in the Content pane and click Properties in the Actions pane to view the alerts for the item selected.
Object Alert text Description Possible cause Solution been changed or the logical disk has failed. An alert will be issued for the logical disk if it has failed. logical disk has failed, see “Recovering from logical disk failure” on page 68. Application data could not be found at path ''. A file cannot be found. File has been moved or deleted. Restore file or revert file using snapshot. Storage has reached its allocated space. No more data can be saved to the allocated storage space.
Object Alert text Description SQL Server Database This database is not in a functional state. Database is offline. SQL Server Data File SQL Server Log Logical Disk 66 Possible cause Solution This database could not be found on host '' . Database has been deleted or renamed. Restore database or change its name back. This database is not attached. This is an expected condition during a restore. No action required. The location of this data file has changed.
Object Alert text Description Possible cause Solution is failing but the other hard drive is still working. Health: Failed redundancy but one mirror still working Logical disk is configured as RAID 1 or RAID 1+0(10). One of the pair of mirrored hard drives has failed but the other hard drive is still working. Hard drive has failed. Replace failed hard drive immediately to restore redundancy. Health: Failed redundancy, the last mirror is failing Logical disk is configured as RAID 1 or RAID 1+0(10).
Object Alert text Description Possible cause Solution Status: Failed Logical disk is not usable. Hardware failure has occurred. See array controller documentation for more information. Recovering from logical disk failure Application component or shared folder data stored on a logical disk that failed is lost.
Glossary This section defines the terms used to describe the ASM user interface and program features. Actions pane The right pane in the main window of the ASM user interface that provides a list of actions, based on your current selection in the Content pane. Along with other selectable items, the Actions pane provides access to storage-allocation wizards, which help you allocate and configure storage.
data protection Protects data from being corrupted or lost as a result of hard drive failure. Methods used to provide data protection include RAID and backups. enforce allocated limit (quota) An enforced quota for the amount of storage available to a shared folder. An enforce allocated limit prevents data from being saved to a shared folder once all the storage space allocated to the shared folder is used. Exchange storage group The fundamental unit of storage management in Microsoft Exchange.
MMC snap-in Microsoft Management Console snap-in. An application added to the Microsoft Management Console. All-in-One Storage Manager is a MMC snap-in. NAS Network-attached storage. This term is used to refer to a specialized type of file server. The HP All-in-One Storage System provides NAS storage as well as iSCSI storage. Navigation pane The left pane in the main window of the ASM user interface that allows you to quickly navigate between HP All-in-One Storage System Management applications.
Status bar The area located at the bottom of the ASM user interface that displays server information and system alerts. tape library An enclosure filled with magnetic tape cartridges, tape drives, and a robot(s). The tapes are electronically labeled for identification and stored in library slots when not in use. When data needs to be written or read from a tape, the robot loads the tape cartridge into an available tape drive in the library.