RE: MSSQL Directory Location

From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 21:15:29 GMT

There is not quick way to determine this with out looking at the files in
the folders.

However, you can look at the following registry keys to determine if any of
the components is in the respective directories:

HKLM\Software\Microsoft\MSSQLSERVER\MSSQLSERVER\Parameters.

Check the parameter values and see which drive they point to. The locations
of the master database files and error log should be lister.

HKLM\System\CurrentControlSet\Services\MSSQLSERVER

Note the entry for the ImagePath. This is where the SQL Server executable
is stored.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Relevant Pages

  • Re: Windows Explorer size reverting to 800x600
    ... I've pre-empted your reply and looking at your script I realise that the ... A similar entry exists in ... All of the folders are on a local drive. ... Const conBagMRUSize = _ ...
    (microsoft.public.windowsxp.general)
  • Re: Cannot access certain sites like Google, Hotmail
    ... > www.google.com or log into my hotmail on my laptop at home. ... where the x's are an ip address or a web site. ... remove the entry. ... You may have to unhide files and folders in your Folder ...
    (microsoft.public.windowsxp.general)
  • Re: Error Code: 0x80070643
    ... you need to restore the registry keys that were deleted in the clean-up. ... and folders" ... Close all Internet Explorer windows. ... Applicable Office versions: Office 2003 ...
    (microsoft.public.windowsupdate)
  • Re: Deleting All Selected Checked files
    ... eSolTec wrote: ... pulls files, folders and registry keys of installed programs. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Deleting All Selected Checked files
    ... to find an uninstaller or to uninstall from a computer. ... folders and registry keys of installed programs. ...
    (microsoft.public.dotnet.languages.vb)