Post reply

SQLVDI error 1060

  • December 22, 2008 at 11:14 am

    #216857

    Hi All,

    I had 2 servers, both running the same stuff (just 2 different subnet).

    I upgraded both to SQL2005. Installation ran fine without errors.

    I had HP DataProtector set to backup each servers SQL using the backup SQL agent.

    The strange thing being that one of them now doesnt like to be backed up as it throws

    SQLVDI: Loc=IdentifySQLServer. Desc=MSSQLSERVER. ErrorCode=(1060)The specified service does not exist as an installed service.

    . Process=2808. Thread=2980. Client. Instance=. VD=.

    I tried to reinstall SQL2005 and everything is green. and while it does check the DB and the install, there is no error.

    Is there anything else I can check?

  • December 22, 2008 at 1:43 pm

    #916378

    try manually installing the backward compatibilty tools from the CD.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 22, 2008 at 1:47 pm

    #916380

    Perry Whittle (12/22/2008)

    try manually installing the backward compatibilty tools from the CD.

    I installed from a internet download and do not have the CD. Is this a particular download name or component I should be looking for?

    this said, having the same software on the same OS and so on, why would only one of them not doing so well with VDI anymore?

    Thanks!

  • December 22, 2008 at 1:51 pm

    #916383

    check this link

    http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

    scroll down and find the MSI package

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 22, 2008 at 2:09 pm

    #916399

    exactly what I found ...SQLServer2005_BC.msi

    well I installed it and restarted all SQL services.

    But I am still getting the very same error in the log when trying to backup that DB

  • December 25, 2008 at 11:37 am

    #917655

    fputhod (12/22/2008)

    I installed from a internet download

    from where exactly?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 30, 2008 at 7:31 am

    #919040

    from the MSFT site...not sure exactly probably from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&DisplayLang=en

  • December 30, 2008 at 12:46 pm

    #919214

    what does the following query return on the server you are having problems on?

    select @@servername

    it sounds as though the sql instance cannot be verified and hence it thinks no service is running for that instance. Possibly as a result of installing\uninstalling sql server.

    What keys are present in the registry for sql server at

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 30, 2008 at 1:30 pm

    #919251

    I would not know what and how about select commands used.

    Basically I have my backup agent Data Protector (HP) that backs up the SQL DB on those servers (updated to 2005 at the same time, see first post).

    One of them is fine and the other one complains about SQLVDI.

    Anyway, this is what I find.

    On both servers I have :

    C:\>reg query "HKLM\software\microsoft\microsoft sql server\instance names\SQL"

    HKEY_LOCAL_MACHINE\software\microsoft\microsoft sql server\instance names\SQL

    WHATSUP REG_SZ MSSQL.1

Viewing 9 posts - 1 through 8 (of 8 total)

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