InfoScale™ 9.0 Storage Foundation Quick Recovery Solutions Guide for Microsoft SQL Server - Windows

To create a dynamic volume from the VEA console

1. Launch Veritas Enterprise Administrator from the Apps menu on the Start screen.

   Select a profile if prompted and connect to the appropriate host.

2. In the tree, expand the system name, expand the storage agent, and then expand Disk Groups.
3. Right-click on the disk group in which to create the volumes (for example, billing_DG), and click New Volume.
4. In the Welcome panel of the New Volume Wizard, click Next.
5. Select the disks for the volume as follows:

   • Make sure the appropriate disk group name appears in the Group name drop-down list.

     For example, billing_DG.

   • For Site Preference, leave the setting as Siteless (the default).

   • Specify automatic disk selection (the default) or manual disk selection. To manually select disks, use the Add button to move the appropriate disks to the Selected disks list. Manual selection of disks is recommended.

   • You may also check Disable Track Alignment to disable track alignment for the volume. Disabling Track Alignment means that the volume does not store blocks of data in alignment with the boundaries of the physical track of the disk.

   • Click Next.

6. Specify the parameters of the volume:
   

   • Enter the volume name (for example, billing_data).

     Note:

     A volume name is limited to 18 ASCII characters. It cannot contain spaces, slash mark (/), backslash (\), exclamation point (!), angle brackets (< >), or equal sign (=). Also, a period cannot be the first character in the name.

   • Enter the size.

   • Select the layout.

   • Select the appropriate mirror options.

   • Click Next.

7. Assign a drive letter to the volume (for example, L: for the billing_data volume) and click Next.
8. Create a file system as follows:

   • Make sure that the Format this volume checkbox is checked and clickNTFS.

   • Select an allocation size.

   • Accept the default file system label, which is the same as the volume name you entered previously or enter a file system label.

   • If desired, select Perform a quick format.

   • Click Next.

9. Review the volume specifications, then click Finish to create the new volume.
10. Repeat the previous steps as necessary to create volumes for the transaction log (for example, billing_log) and any other database in your configuration.

To create a volume from the command line

1. Type the CLI commands as in the following examples:

   > vxassist [-b] -gbilling_DG make billing_data L:
   > vxassist [-b] -gbilling_DG make billing_log M:

   These example commands will create volumes in the billing_DG disk group named billing_data and billing_log on drive letters L and M respectively.

2. Modify and repeat this command as necessary to create additional volumes.

   For the complete syntax of the vxassist make command, see Storage Foundation Administrator's Guide.