Avatar of hongedit
hongeditFlag for United Kingdom of Great Britain and Northern Ireland

asked on 

SQL Server keeps losing drive letter

Hi

This is a virtual server, that until today had no problems I am aware of.

I have the OS installed on C and a seperate virtual drive for the actual DB (B:\)

Everytime I reboot the DB Drive is missing its drive letter. Even after I reassign it, I cannot start the SQL service - error in eventlog:

Log Name:      Application
Source:        MSSQLSERVER
Date:          16/05/2011 14:45:38
Event ID:      17053
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      Saints-SQL.Saints.local
Description:
FCB::ZeroFile(), GetOverLappedResult(): Operating system error 19(failed to retrieve text for this error. Reason: 15105) encountered.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSSQLSERVER" />
    <EventID Qualifiers="49152">17053</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2011-05-16T13:45:38.000000000Z" />
    <EventRecordID>6947</EventRecordID>
    <Channel>Application</Channel>
    <Computer>Saints-SQL.Saints.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>FCB::ZeroFile(), GetOverLappedResult()</Data>
    <Data>19(failed to retrieve text for this error. Reason: 15105)</Data>
    <Binary>9D420000100000000B0000005300410049004E00540053002D00530051004C00000000000000</Binary>
  </EventData>
</Event>
Microsoft SQL ServerVMwareWindows Server 2008

Avatar of undefined
Last Comment
hongedit
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

Is that the letter B:

A: and B: are sometimes reserve for floppy disk drives.

Have you removed the floppy disk drive from the virtual machine.

Have you tried a different drive letter?
Avatar of hongedit
hongedit
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Yes, that is the letter B.

I dont understand, it worked fine for a week. Just noticed it today that it wasnt working.

I will try removing the floppy disk.

I could change the letter, but I am unsure how to tell SQL where to look for the database if i do so
So if you got into Disk Management, the Drive is not assigned A letter?
Avatar of hongedit
hongedit
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Well, removing floppy didnt work.

The first time I checked this out, Disk Management listed the Drive as offline.

So I right click, select Online, and give it the driver letter back.

Now, everytime I reboot, the drive stays online but the drive letter is missing.

Even after I give it a drive letter back, SQL will not start.
I would recommend using drive letters that are reserve A: and B:.

I've never known anyone ever use Drive A: or Drive B:, usually drives letters are used after the first fixed disk C:.

e g. D:

Yes, it's because the drive probably needs to be available to SQL at boot-up, at service start, as the disk is missing, SQL cannot start.

an article here about moving SQL disks

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/5c0e5ba5-1e1a-4c38-ac92-3e5c50ac6c7b/
Avatar of hongedit
hongedit
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

There is one big problem - I cannot start Managment Studio to move the DB's to a new drive letter!
have you re-assigned the drive letter as B:

and SQL doesn't start?
Avatar of hongedit
hongedit
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Correct
If you cannot get SQL started, you are probably going to have to copy and move the data separately.

and follow this...

http://www.psoft.net/HSdocumentation/sysadmin/mssqlchangehome.html

but the issue you have is the B:, and it may be better to build a new server. and install SQL on C: or D: etc
Avatar of hongedit
hongedit
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

I dont think its the B causing the issue.

I reassigned it as J, rebooted, still lost the drive letter!
You've not got the Virtual Machine Disk set to Non-Persistent for the VM?
Avatar of hongedit
hongedit
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Nope
ASKER CERTIFIED SOLUTION
Avatar of hongedit
hongedit
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
I would sanity check your environment.

Something is not right.
Avatar of hongedit
hongedit
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

I agree, its driving me mad.

I dont even know where to start though.
Avatar of hongedit
hongedit
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thanks
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo