August 2, 2017 at 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
August 2, 2017 at 8:49 am
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)
August 2, 2017 at 9:27 am
Mappings can be set/saved by user. Perhaps the service account has a mapping you don't have.
August 2, 2017 at 10:14 am
narayanamoorthy.a - Wednesday, August 2, 2017 8:38 AMHi,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 queryselect name, physical_name from sys.master_files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" š
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply