SQL Server Performance Forum – Threads Archive

Create Your Own Log Shipping Scripts

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]

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.

]]>