Add storage in SQL Server cluster

Assuming that I have to add new storage in my SQL Server 2008 cluster.

Prerequisites

• Make sure the shared disks are ready for the SQL Server 2008 cluster

Lab environment

• DB02 is member of the SQL Server 2008 cluster with 1 shared disk.

Goal

Add 2 shared disk in SQL Server 2008 cluster

1. On the DB02, log in as Domain Administrator.

2. Launch "Failover Cluster Management".

3. Expand "[Cluster name] > Storage".

4. Right-click "Storage", select "Add a disk".

5. Select the disks and then click "OK".

6. Expand "Services and Applications > SP10SQLGroup01".

Remark: "SP10SQLGroup01" is a group name for SQL Server 2008 cluster in my test environment.

7. Right-click "SP10SQLGroup01", select "Add storage".

8. Select the disks.

9. Click "OK".

10. Right-click "SQL Server", select "Properties".

11. Select "Dependencies" tab.

12. Click "Insert".

13. Under "Resouerce", select "Cluster Disk 4".

14. Click "Insert".
15. Under "Resouerce", select "Cluster Disk 5".

16. Click "OK".

17. Close "Failover Cluster Management".

As a result, the SQL server 2008 cluster can use the other shared disk.

This posting is provided “AS IS” with no warranties, and confers no rights!

Event ID 11316, MsiInstaller

Symptom

When the SQL Server 2008 is installing on the server, it shows the following error.

The following error has occurred:

A network error occurred while attempting to read from the file path\SQLD6B0.tmp.msi

Then I checked the event log. I found a error event Event ID 11316, MsiInstaller.

Product: Microsoft SQL Server 2008 Native Client -- Error 1316. A network error occurred while attempting to read from the file path\SQLD6B0.tmp.msi

Remark: When you get the error, the file name ," SQLD6B0 .tmp.msi", may be different.

Cause

Because I had performed "Install software prerequisites" of "SharePoint Server 2010", the "Microsoft SQL Server 2008 Native Client" was installed on the server.

Solution

1. Uninstall "Microsoft SQL Server 2008 Native Client".

2. Perform Microsoft SQL Server 2008 again.

This posting is provided “AS IS” with no warranties, and confers no rights!