SQL Server Performance

Help on Log Shipping set up

Discussion in 'SQL Server Log Shipping' started by ridgedawg, Sep 24, 2006.

  1. ridgedawg New Member

    I read through the article on this site for Log Shipping and when I run the job to do the restore of the database on the standy server, I get the following error:

    Could not relay results of procedure 'restore_database_backups' from remote server '192.168.100.10'. [SQLSTATE 42000] (Error 7221) [SQLSTATE 01000] (Error 731212)

    Any help would be greatly appreciated!
  2. hnarayanan19 New Member

    this can be the solution for this problem but i am not sure just try it out. before u run the restore command you have to fire the command below. see what the name of the file given as(this name can change). i am not sure u can try it out. i had the same problem but that time i was restoring the whole database on a different server. if u need i can give u the restore command also.

    RESTORE FILELISTONLY
    FROM DISK ='c:MSSQLABCD.BAK'
    go


    RESTORE DATABASE ABCD
    then ur command will come



    Thanks,
    Narayanan
  3. ridgedawg New Member

    I tried the code you posted but I still got the same error - the stored procedure I'm using is this:

    CREATE PROCEDURE restore_database_backups AS
    BEGIN
    RESTORE FILELISTONLY
    FROM DISK ='D:ackup_pointdatabase_backup_device.BAK'


    RESTORE DATABASE [database]
    FROM DISK = 'D:ackup_pointdatabase_backup_device.BAK'
    WITH
    REPLACE,
    STANDBY='D:ackup_pointundo_database.ldf',
    MOVE 'database_Data' TO 'D:ackup_pointdatabase.mdf',
    MOVE 'database_Log' TO 'D:ackup_pointdatabase_log.ldf'


    WAITFOR DELAY '00:05:05'
    END
    GO

    Thanks in advance for the help.
  4. hnarayanan19 New Member

    NO i did not mean that. what i meant was run this filelistonly command first alone. no stored procedure initially.
    RESTORE FILELISTONLY
    FROM DISK ='D:ackup_pointdatabase_backup_device.BAK'
    then see what result it gives u. see what is the physical name that it gives of the data file and the log file. now u should have the same path in the restore statement also.
    STANDBY='D:ackup_pointundo_database.ldf',
    MOVE 'database_Data' TO 'D:ackup_pointdatabase.mdf',
    MOVE 'database_Log' TO 'D:ackup_pointdatabase_log.ldf'



    Thanks,
    Narayanan
  5. ridgedawg New Member

    I ran the command beforehand to get the logical names of the files. I thought that the MOVE command would basically tell the restore where it would place the data and the log on the standby server?
  6. hnarayanan19 New Member

    is the matter resolved now or u have problems still i cud not get this from the reply that you gave.

    Thanks,
    Narayanan
  7. ridgedawg New Member

    The error still persists. We don't have the exact same setup on the remote server as far as hard drives, so on the MOVE command I just specify a different drive with the filename. Is that ok to do or would that cause this type of problem?
  8. hnarayanan19 New Member

    do step by step first run the filelistonly command on the destination server. give the path of the backup file correctly in filelistonly command and send me the physical file names (both data and log). i will write down the restore and send it to u

    Thanks,
    Narayanan
  9. ridgedawg New Member

    database_Data,F:DATABASEMSSQLDatadatabase.mdf,D,PRIMARY,10734665728,3.51844E+13
    database_Log,E:SQL_LOGSdatabase_log.ldf,L,NULL,1920073728,3.51844E+13
  10. hnarayanan19 New Member

    MOVE 'database_Data'TO 'F:DATABASEMSSQLDatadatabase.mdf,D,PRIMARY,10734665728,3.51844E+13
    ',
    MOVE 'database_Log' TO 'E:SQL_LOGSdatabase_log.ldf,L,NULL,1920073728,3.51844E+13'

    I dont thk u can move the database data and log file to different location. but i will surely confirm it and let u know, someitme later today for sure


    Thanks,
    Narayanan
  11. ridgedawg New Member

    Hey Narayanan,

    I resolved the problem. It was in the time it was taking to execute the remote stored procedure. I adjusted the time that the connection would run and it worked. Thanks for taking the time to help me out. It's much appreciated!

Share This Page