Note: Just before 圆4 folder (as shown below)įiles\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\圆4 ) Since it is an already installed instance I can see it's setup file here "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2" Programms>Microsoft SQL Server 2008 R2>Configuration Tools>SQL Server Installation Center (64bit)>Run As Administrator To repair an existing instance do we have to select installation center: All
Ok now it's clear for me on how to find the setup file location.
In regards to my early question and as per my observation I have found that below location can direct to setup file:Īll Programms>Microsoft SQL Server 2008 R2>Configuration Tools>SQL Server Installation Center (64bit)>Right Click>Open File Location: Directing to LandingPageĬ:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\圆4įrom setup Bootstrap we can see log folder there Summary text file can be seen, here we can find the setup file location. Now here we are drafting precautionary measures and roll back procedure hence collecting all available setup file locations: Now we don't have SQL Setup file location which is considering as a hurdle to install new instances & repair existing instance (if required) & rollback service pack may require un-install and install new instance in worst scenarios. In this perspective even we are short of details we want to upgrade Service Packs initially one after another but here our challenge is that these servers are earlier maintained by other DBA's and we are left with no useful information, in these scenarios To be clear, we are maintaining few servers and want to propose implementations as per the Microsoft best practices.