SQL Server Performance

Log shipping restoration Problem

Discussion in 'SQL Server Log Shipping' started by edutsilva, Nov 18, 2008.

  1. edutsilva New Member

    Dear Sir,
    I’m from Brazil and very inexperienced in SQL Server. I need some advice. Please help me.
    I’ve been trying to implement a log shipping procedure using the guide wrote by Mr. Brad M. McGehee (http://www.databasejournal.com/features/mssql/article.php/1467581/How-to-Do-SQL-Server-Log-Shipping.htm) and I’m having trouble to make it work. The restoration process fails. Not sure why. Maybe I did something wrong when creating the stored procedures but I just can’t find the error.
    After reviewing the SQL Job log, I found this error message:
    Could not obtain a required interface from OLE DB provider 'ADsDSOobject'.[SQLSTATE 42000][error 7301]. The Step Failed.

    In my case, I use the following variables:
    Database name: ALTERDATA
    Databse files: ALTERDATA_MODELO.mdf and ALTERDATA_log.ldf
    Backup Devices: ERP_DB_BK_DEVICE.BAK and ERP_LOG_BK_DEVICE.BAK
    STANDBY SERVER NAME: PET300
    ________________________________________________________________________
    CREATE PROCEDURE restore_database_backups AS

    RESTORE DATABASE ALTERDATA
    FROM DISK = 'D:LSERP_DB_BK_DEVICE.BAK'
    WITH
    DBO_ONLY,
    REPLACE,
    STANDBY = 'D:SQL_DADOSMSSQLDATAUNDO_ALTERDATA_LOG.ldf',
    MOVE 'ALTERDATA_MODELO' TO 'D:SQL_DADOSMSSQLDATAALTERDATA_MODELO.mdf',
    MOVE 'ALTERDATA_LOG' TO ' D:SQL_DADOSMSSQLDATAALTERDATA_log.ldf’

    WAITFOR DELAY '00:00:05'

    EXEC sp_dboption 'ALTERDATA, 'single user', true
    ________________________________________________________________________
    CREATE PROCEDURE restore_log_backups AS

    RESTORE LOG ALTERDATA
    FROM DISK = 'D:LSERP_DB_BK_DEVICE.BAK'
    WITH
    DBO_ONLY,
    STANDBY = 'D:SQL_DADOSMSSQLDATAUNDO_ALTERDATA_LOG.ldf',

    WAITFOR DELAY '00:00:05'

    EXEC sp_dboption 'ALTERDATA, 'single user', true
    _____________________________________________________________________
    The job steps failing look like this:
    EXEC PET300.master.dbo.restore_log_backups
    And
    EXEC PET300.master.dbo.restore_database_backups
    What am I doing wrong? Please, help.
    Yours,
    Eduardo Teixeira
  2. MohammedU New Member

    I believe it is linked server issue...
    Make sure your linked server configuration is correct and you can access the data and execute the procedure via linked server...
  3. edutsilva New Member

    I think you´re correct but I still don't know how to solve the problem. When I try to access the standby (linked) server tables, I get the following error:
    Error 7301: Could not obtain a required interface from the OLE DB provider 'ADsDSOObject'. OLE DB error trace [OLE/DB Provider 'ADsDSOObject' Unknown:: QueryInterface returned ... IDBSchemaRowset].
    in different words, it's the same error I found in the job history report. Can someone please help?
    Yours,
    Eduardo



  4. ghemant Moderator

    Hi,
    You would required to run sp_addlinkedserver to add server (this you will require to run at both server ) and sp_addlinkedsrvlogin (to map a login on a remote/linked server, this also requires to run on both server)
    Suggests you to refer BOL for sp_addlinkedserver and sp_addlinkedsrvlogin and refer this link for better understanding http://msdn.microsoft.com/en-us/library/ms188279(SQL.90).aspx
    hth

Share This Page