FrontDeskSoft
asked on
Restore SQL 2008 Deleted C Drive Directory - SQL Browser & Manager Will Not Run
We went to try to install Microsoft SQL Server 2008 R2 onto a clients server (2008 R2 is the version the client has a license for). We discovered that SQL 2008 (not R2) had already been installed. When we went to run SQL Server Manager, we found that the SQL Server directory on the C:\ drive had been deleted. Both SQL Server Manager and SQL Browser will not run because the directory had been deleted. We went to install 2008 R2 - SQL database installed but SQL Server Manager would not install saying that an earlier version had been installed. We went to try to start SQL Browser again, but it did not re-install either and will not run because the file is still missing.
Another problem is that they have SharePoint running on the SQL database that is installed. We thought about re-installing SQL server but how will this affect the instance of SharePoint?
We suggested that they have a separate computer to run SQL Server but "they didn't like the idea."
Any suggestions on how to recover the installation without affecting/destroying their instance of SharePoint?
Thanks very much for any suggestions!
Another problem is that they have SharePoint running on the SQL database that is installed. We thought about re-installing SQL server but how will this affect the instance of SharePoint?
We suggested that they have a separate computer to run SQL Server but "they didn't like the idea."
Any suggestions on how to recover the installation without affecting/destroying their instance of SharePoint?
Thanks very much for any suggestions!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would suggest you manually uninstall SQL Server as described here:
SQL Server 2008 installation fails when you try to install SQL Server a second time
SQL Server 2008 installation fails when you try to install SQL Server a second time
Is SharePoint even functional? If not, I'm guessing the databases were lost when the directory was deleted. In which case there isn't a threat of screwing something up in SharePoint as it's already lost. Just reinstall SQL, run the SP Config Wizard and create a new farm.
If SHarePoint is up and running it must be because the database files are on a different directory. If this is the case I would find them and make a copy of all the files. Then reinstall SQL and reattach the databases (which should upgrade them to R2). Best case, SP will continue to work and won't even know anything happened.
If SHarePoint is up and running it must be because the database files are on a different directory. If this is the case I would find them and make a copy of all the files. Then reinstall SQL and reattach the databases (which should upgrade them to R2). Best case, SP will continue to work and won't even know anything happened.
ASKER
Thanks everyone for you help. I was finally able to get out to the clients site. I actually found a old SQL 2008 disc that worked to restore SQL.
Thanks!
Thanks!
ASKER
Thanks very much for your help!