Skip to Content
author's profile photo Former Member
Former Member

DB upgrade from 2005 to 2008

Hi,

We are upgrading our SQL Server database 2005 Sp2 to 2008 R2.
During the process of upgrade we are facing issues, "SQL Server 2008
R2 has completed with failures"

Detail: LOG

2012-04-21 23:11:09 Slp: Error result: -2068119551
2012-04-21 23:11:09 Slp: Result facility code: 1211
2012-04-21 23:11:09 Slp: Result error code: 1
2012-04-21 23:11:09 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-04-21 23:11:09 Slp: Sco: Attempting to open registry subkey
2012-04-21 23:11:09 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
2012-04-21 23:11:09 Slp: Sco: Attempting to get registry value DW0201
2012-04-21 23:12:04 Slp: Submitted 1 of 1 failures to the Watson data repository

Please suggest.

Regards,

Mag

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2012 at 03:00 PM

    HI,

    I havent run STM tools yet and also in services.msc i can see that SQL DB services has started and is running with 10.5 version. but agent is still with 9,0 version and unable to start it.

    Please suggest .

    Regards,

    Mag.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      HI Eduardo,

      Initially we tried to install using "Administrator" but installation completed with errors, Later tried with SID adm users multiple times but it stopped at Step3: "Select features"

      1) Is there any way i can Uninstall 2008 db and revert back to 2005 and then reinstall the upgrade activity of SQL Server 2008

      Please suggest

      Regards,

      Mag.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.