Hi everyone.
I have a question that maybe some of you may be able to shed some light
on. My set up involves three SQL Server Databases. First one, used by
the application. Second, copy of first via log shipping. Third,
contains data aggregation from the Second. Now, my issue is that I
have a DTS packagage that (COPY SQL SERVER OBJECTS) that copys select
tables from the second DB, into the third. The issue lies when the DTS
package executes, everyonce in a while it errors out. I'm assuming
it's an error due to the log shipping restore on the second database.
Are there any solutions to this?
TIA