By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

Potential issue with DTS and Log Shipping

P: n/a
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

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

<gu********@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
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


One possible solution could be to check DATABASEPROPERTYEX('MyDB', 'Status')
either before executing the package or within the package itself - if it
isn't online then you can wait for an appropriate period of time and try
again.

Simon
Jul 23 '05 #2

P: n/a
Thanks! That's a HUGE help.

thanks again.

-A

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.