SQL Server Performance

Create Your Own Log Shipping Scripts

Discussion in 'SQL Server 2005 Log Shipping' started by jimd, Mar 22, 2006.

  1. jimd New Member

    Has anyone had any luck creating their own backup shipping scripts for MSSQL 2005 Standard?
    I have been trying all day and the furthest I got was to my last step when the recovery is supposed to happen on the "standby server". I got a weird error saying that I couldn't make a heterogeneous query when using an OLEDB provider in fiber mode. I can't find any info on this error.
    your help is much appreciated![8D]
    jimd, Mar 22, 2006
    #2

  2. satya Moderator

    Last time I was trying to use PROFILER during this process and capture the used SQL statements in this case, still working on it.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Mar 23, 2006
    #2

Share This Page