HP AiO400r HP StorageWorks All-in-One Storage System User Guide (440583-005, F - Page 66
Selecting a database workload type, Table 18 Selecting database components to host
View all HP AiO400r manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 66 highlights
1. Do one of the following: • Select all components (including all of its components) by checking the box next to the component. • Select individual database components by expanding the list and checking the boxes next to the components. You must select all the database components, including the log file, in a database if you want to run backups and/or take snapshots of the database using ASM. NOTE: ASM cannot migrate system databases; for example, ASM cannot migrate master, model, msdb and tempdb. The following table lists the action ASM can perform for each database component listed. Table 18 Selecting database components to host Action None Allocate Space, Move Data None, Already Managed Description Component's check box is not selected, so ASM will not perform any action. Select check box to change action. Storage space will be allocated and configured on your HP All-in-One Storage System. Component's data will be migrated to your HP All-in-One Storage System. Component's data is already hosted on your HP All-in-One Storage System and already managed by ASM. No action is possible. 2. To view the properties for a database component, select the database component name and then click Properties. See "Data file properties" on page 101 and "Log file properties for database" on page 101 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 successful migration checkbox. 4. When you are done, click Next to open the Select the Database Workload Type page (see "Selecting a database workload type" on page 66). Selecting a database workload type Use the Select the Database Workload Type page to select the workload type for the SQL Server database. NOTE: You can only select the database workload type while using the Host a SQL Server Database Wizard. The database workload type cannot be changed later. 66 Hosting storage for applications and shared folders