Wednesday, June 4, 2014

Cannot Access the Specified Path or File on the Server

Symptom:

Cannot Access the Specified Path or File on the Server on SQL Server Failover Clustering when attached database or create new filegoups

First troubleshooting attempt:

Verify whether disk is part of cluster resource and SQL Server shall have dependency on it. Yes, this is configured as part of Cluster Storage used by SQL Server Instance.

Second troubleshooting attempt:

Anything wrong with the disk? Check through “Computer Management” –> “Disk Management”, surprisingly, the disk status is “Active, Primary Partition”, but other clustered disks only listed as “Primary Partition”

What does active mean? It means the volume is capable of containing an operating system bootable image. But this should not be the case for a disk used purely for SQL Server Databases.

After turn it off, problem resolved.

Steps to turn it off:

Start Administrator Command Prompt:

image

DISKPART> list disk

  Disk ###  Status         Size     Free     Dyn  Gpt
  --------  -------------  -------  -------  ---  ---
  Disk 0    Online           100 GB     0 B
  Disk 1    Online           100 GB 1024 KB
  Disk 2    Reserved       5000 GB  1984 KB
  Disk 3    Reserved       5000 GB  1024 KB

DISKPART> select disk 3

Disk 3 is now the selected disk.

DISKPART> list partition

  Partition ###  Type              Size     Offset
  -------------  ----------------  -------  -------
  Partition 1    Primary           5000 GB  1024 KB

DISKPART> select partition 1

Partition 1 is now the selected partition.

DISKPART> inactive

DiskPart marked the current partition as inactive.

DISKPART> exit

Leaving DiskPart...