Drive Letter Issue

• narayanamoorthy.a

  Ten Centuries

  Points: 1272

  More actions

  August 2, 2017 at 8:38 am

  #332087

  Hi,

  The database data(MDF) and log(LDF) files are mapped to L:\ drive and the database is online/active. However there is no driver letter L:\ under the disk that I see from My Computer/Computer Management. The SQL version is Microsoft SQL Server 2014 - 12.0.4100.1 (X64) and not a cluster. I’m wondering how the database is online ?

  Regards,
  NM

• jasona.work

  SSC Guru

  Points: 50170

  More actions

  August 2, 2017 at 8:49 am

  #1953787

  When you say:
  

  mapped to L:\ drive

  
  what exactly does this mean?
  Is this a network drive, mapped to a share on another server or NAS?
  If so, mapped drives do not show up in Computer Management->Disk Management (these are local drives only)

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737751

  More actions

  August 2, 2017 at 9:27 am

  #1953793

  Mappings can be set/saved by user. Perhaps the service account has a mapping you don't have.

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  August 2, 2017 at 10:14 am

  #1953811

  narayanamoorthy.a - Wednesday, August 2, 2017 8:38 AM

  Hi,

  The database data(MDF) and log(LDF) files are mapped to L:\ drive and the database is online/active. However there is no driver letter L:\ under the disk that I see from My Computer/Computer Management. The SQL version is Microsoft SQL Server 2014 - 12.0.4100.1 (X64) and not a cluster. I’m wondering how the database is online ?

  Regards,
  NM

  What is the operating system running on this machine?
  What does the following PoSh query return?
  Get-Volume | ?{$_.DriveType -eq "Fixed" -and $_.FileSystemLabel -ne "System Reserved"} | ft DriveLetter, FileSystemLabel, FileSystem, HealthStatus, @{N="Size"; E={"0:N2" -f (size / 1MB)}}, @{N="SizeRemaining"; E={"0:N2" -f (SizeRemaining / 1MB)}}

  And this TSQL query
  select name, physical_name from sys.master_files

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs"