I have a legacy Windows 2003 Server that hosts an MS SQL server DB. The mdf and ldf files of said DB are stored on network mapped drives. One day the DB encountered errors only for us to find out that the mapped drives are gone. Is there any way to check or retrace the hosts of those mapped drives? And restore them for the DB to work properly again?

  • did you checled net use? – djdomi Sep 11 at 17:04
  • What do you mean check or retrace the hosts of those mapped drives? Do you mean find the server where those files were? – joeqwerty Sep 11 at 17:18

If I understand you correctly you lost the network drives the SQL DB files were on. This is a very odd construct. You could find the drives in regedit under Computer\HKEY_USERS\ {user guid} \Network if they havent been removed with net use /del ie. If you find the path there, you could try to recreate the exact drives, paths and files. If you have consitent files at the right location SQL server should start the dbs again.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.