weird "no disk in the drive" message

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

weird "no disk in the drive" message

Author

Topic

gdeconto
Posting Yak Master

107 Posts

Posted - 2002-04-11 : 12:12:32

We setup our win2k sql2k server a couple of months ago.

We noticed that for some reason, everytime we tried to do a restore we got this message:

"There is no disk in the drive. Please insert a disk in drive A:"

We don't remember using the floppy (aside from creating the emergency disk when we installed win2k. We haven't done any backups or restores from floppy. There does not appear to be any other program that uses the floppy (who uses floppies anymore anyhow?!?). There are no entries in the registry that we can find.

We'd like to get rid of this since it is a pain when you are administering sql2k remotely.

Has anyone else experienced this?? Does anyone have a fix??

All help appreciated.

Nazim
A custom title

1408 Posts

Posted - 2002-04-11 : 12:37:31

Are you using EM to restore the DB ?

if so on the Restore Screen . Click on Options Tab and change the path at Restore as Text boxes.

HTH

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

gdeconto
Posting Yak Master

107 Posts

Posted - 2002-04-14 : 12:08:51

Hi Nazim. THx for the response.

yes, I am using EM to do the restores.

however, I am not sure your suggestion will help because of how I do a restore. For example, when I use EM on my desktop to do a restore and am looking at the first restore screen:

1. a bunch of default values (ie the first database in the list of databases is already selected) exist that are not what I need
2. I choose From Device
3. if I go to the options tab, all the entries are blank, because I have not chosen a device yet; could this be the problem: no defaults?
4. I press the Select Devices button
5. I select the Add button
6. I select the File Name "..." button
7. the "No disk" message appears on the sql server desktop
8. I then have to go to the sql server to kill that message before I can resume the restore
9. I can then choose the file to restore and continue with the restore process

Note that ALL of the backups were done to a hard drive so none should be referencing the floppy drive.

Any other ideas?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources