Can't re-install sql server 2008 after crash

  • We had a server crash (bad hard drive) and I re-installed server from tapes (backup exec 12.5)everything works OK except for SQL server. I tried to un-install it at program & Features and it looked like it ran, but now when I try to reinstall it doesn't give me any features to install. That page in the install is blank. I went to the setup command line and tried to uninstall the feature and I got a error message that said the items (SQL, etc) weren't installed.

    SQL Server 2008 running on windows server 2008 R2

    Any Idea where i can go from here

  • any error messages?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • mccarron52 (4/7/2011)


    We had a server crash (bad hard drive) and I re-installed server from tapes (backup exec 12.5)everything works OK except for SQL server.

    If you re-installed and every thing is working fine except SQL server, If Sql server not working then what is working fine?

    I tried to un-install it at program & Features and it looked like it ran, but now when I try to reinstall it doesn't give me any features to install. That page in the install is blank. I went to the setup command line and tried to uninstall the feature and I got a error message that said the items (SQL, etc) weren't installed.

    SQL Server 2008 running on windows server 2008 R2

    Any Idea where i can go from here

    As per my expereance SQL server not properaly un-installed from system,

    can you posth the exact error, you should check also bootstrap folder

    Ali
    MCTS SQL Server2k8

  • not receiving error messages when trying to reinstall. Did not receive any during uninstall. When I try to reinstall the features page where you select what to install is blank like all the features are all installed. There is no longer any SQL server directory.

    Other things working on server are AD, DHCP, DNS, file services, web sevices

  • You will have to manually uninstall sql server

    refer to this kb

    http://support.microsoft.com/kb/955404

    And then install a fresh copy

    Alex S
  • An error occurred during the SQL Server 2008 Setup operation.

    Error result: -2067529698

    Result facility code: 1220

    Result error code: 30

    For more information, review SQL Server 2008 Setup logs in your temp folder.

    Any idea what this error message means?

    I don't see any logs in c:\temp. Still looking

  • try c:\windows\temp or your user temp directory for those logs.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • mccarron52 (4/8/2011)


    An error occurred during the SQL Server 2008 Setup operation.

    Error result: -2067529698

    Result facility code: 1220

    Result error code: 30

    For more information, review SQL Server 2008 Setup logs in your temp folder.

    Any idea what this error message means?

    I don't see any logs in c:\temp. Still looking

    Check the logs in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\LOG folder for possible reasons for failure.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • In Order to install again go to run and type REGEDIT and there under softwares->Microsoft-->SQL Server -->delete this SQL Server folder and try to install the SQL Server Again

  • mccarron52 (4/8/2011)


    Other things working on server are AD, DHCP, DNS, file services, web services

    This is not a criticism. I'm only commenting for the benefit of you and your company.

    It is definitely NOT a best practice to have the other products you mention ("AD, DHCP, DNS, file services, web services") executing on the same server as your SQL Server.

    I know that sometimes, for reasons of economy, companies must do this but if you have the option to move SQL Server or the other products to different servers, I would do so. Doing so is most likely to give you the best results for all of the products and especially SQL Server.

    LC

  • Moving those other item is usually how we operate, but the office I am working is very small and we only have one server here. The database is very small and the only reason for using SQL server is that the front-end package requires it. The use of the database will be minimal compared to many organizations, so there are no performance issues, at least not yet.

    By the way there was so little to install that I reinstalled the OS and SQL so I no longer have my original problem.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply