Post reply

Microsoft SQL-DMO (ODBC SQL State 42000)

  • May 14, 2004 at 8:25 am

    #87153

    Hi,

    I get an error-- Microsoft SQL-DMO (ODBC SQL State 42000) ---

    while restoring the complete backup on a different machine.

    Is it due to some logins not existing in this new sql server which were there on the sql servre i had the backup done..

    Pl. help

    Thanks,

    Reshu

    Naveen

  • May 15, 2004 at 9:34 am

    #506568

    This is very generic, please post more of the error message, esp what comes right after the 42000.

  • May 15, 2004 at 11:48 am

    #506572

    I am afraid there is only this as the error message.

    Ok let me know one thing, if i try to restore backup to a different machine which has no logins/users defined as there were in the machine i initially had taken the backup from...what will be the result....

    such users/logins will be ignored..or they will be there in database but with no mapping to sql server logins....

    Pl. help

    Thanks,

    Reshu

    Naveen

  • May 15, 2004 at 7:04 pm

    #506574

    I doubt it's the users/logins, have successfully restored many DBs w/these out of sync.  Maybe it's the path or something, though. 

    If you can't get rest of error message, can you try to accomplish this in a way that will show you the error, e.g. use TSQL restore syntax in Query Analyzer.  If you don't know what command is being executed you should be able to capture it in profiler.

  • May 16, 2004 at 2:02 pm

    #506587

    Ok let me know one thing, if i try to restore backup to a different machine which has no logins/users defined as there were in the machine i initially had taken the backup from...what will be the result....

    such users/logins will be ignored..or they will be there in database but with no mapping to sql server logins....

    The database will be restored fine.  There of course will be no users on the server to match the users in the database though.  You will need to add them then sync up the users using sp_change_users_login.  It definitely doesn't produce this error.

    Also, are you running SQL Server 2000 or 7.0?  Please refer to the following articles:

    http://support.microsoft.com/?kbid=814579

    Also, you need to make sure you have the latest service packs and updates on your SQL Server installations.

     

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

Viewing 5 posts - 1 through 4 (of 4 total)

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