October 18, 2011 at 3:55 am
I am trying to identify the location of SQL install. My research has identified that I need to look into the following place on the registery:
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products\<Product_Code>\SourceList\LastUsedSource
However how can I Identify the <Product_code> for SQL 2005?
October 18, 2011 at 5:25 am
Have you looked at the following : it shows GUIDS
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\SqlWriter\MSIRefCount
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}
Anyone else?
Matt
October 18, 2011 at 9:45 am
I can't find this in the registery key
October 18, 2011 at 10:05 am
Are you trying to do this programatically?
Otherwise just look at the service manager, open the SQL service, the path to the service is listed there.
CEWII
October 18, 2011 at 10:12 am
Sorry didn't phrase this correctly I want the location SQL is installed from
October 18, 2011 at 10:20 am
Ah, sorry, know I've seen that but not where.
And why do you care?
CEWII
October 18, 2011 at 10:31 am
I am rehearsing DR senarios. One senario is that we have no back for the master database and have to rebuild it (we backup all our system databases, but this is testing worse case senarios.) One of the problem I have found with 2005 rebuild is that you need to run the rebuild from the location you installed from.
October 18, 2011 at 10:46 am
I disagree, the location that they were installed from indicates the medium used to install it, that has no bearing in this scenario. You need to know the location it was installed TO, also rebuilding master loses a LOT. For your scenario you need to know all the paths for every single database file. You also need to periodically script out all your logins with hashed passwords and their server SID. Also need to script out all jobs.
As an aside, I make it a habit to have safe copies of master at all times, the safety copy my not be absolutely current but it is better than starting over.
CEWII
October 19, 2011 at 1:48 am
Also disagree , all you need to do is follow this from MS
http://msdn.microsoft.com/en-us/library/ms143269(v=sql.90).aspx
All you need is the media to do this with , not the previous installation path...
Thats if the worst comes to the worst and you dont have a master backup.....
October 19, 2011 at 2:06 am
Sorry but you are both wrong:
http://geekswithblogs.net/normski_blog/archive/2007/03/01/107662.aspx
There is a Microsoft link as well but I cannot find it. Anyone able to answer my inital question ?
October 19, 2011 at 2:09 am
microsoft link:
October 19, 2011 at 2:13 am
That mentions the same thing , using setup.exe to rebuild the master database , the same as i posted.
The link in YOUR post links to :-
How to: Install SQL Server 2008 R2 from the Command Prompt
Which is not SQL 2005.
October 19, 2011 at 2:15 am
Fair point , but in that MS article it shows you how to work around it , so havnt you answered you own question?
October 20, 2011 at 7:27 am
I'm on my droid so I can't look it up, but a few months ago I faced the same problem and requirements. Look inside the setup bootstrap, one of the install log files has the location of the setup.exe.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy