Administrator Guide

e. Click Add. The Add Drive Letter or Path dialog box appears.

f. Select an available drive letter or mount point and click OK.

3. On the database server, clear the VSS attributes from each volume.

a. Open a Command Prompt window.

b. Start the disk part utility by typing diskpart and pressing Enter.

c. For each volume, type the following commands, pressing Enter after each command.

NOTE: To see a list of all available volumes, type: list vol

Select the volume using the volume number or drive letter with one of the following commands:

select vol number

- or -

select vol letter :

Clear the read-only attribute:

attrib vol clear readonly

Clear the hidden attribute:

attrib vol clear hidden

Clear the shadow copy attribute:

attrib vol clear shadowcopy

Validate that the attributes have been cleared:

attrib vol

When the attributes have been cleared, the output will look like this:

Read-only : No

Hidden : No

No Default Drive Letter: Yes

Shadow Copy : No

d. Exit the diskpart utility by typing exit and pressing Enter.

e. Close the Command Prompt window by typing exit and pressing Enter.

4. Attach the desired databases from the new volumes.

For information about how to attach SQL Server databases, see the Microsoft SQL Server books

online documentation.