473,326 Members | 2,438 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Potential issue with DTS and Log Shipping

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
2 1130

<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
Thanks! That's a HUGE help.

thanks again.

-A

Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Jason Huang | last post by:
Hi, In the MS SQL 2000 Server, if the log shipping is set up right, does that mean data in primary server changed will mapped to secondary server later on? Thanks. Jason
0
by: InProcess | last post by:
We have successfully implemented Log Shipping between two MS SQL Server 2000 servers (bothe SP3). The problem we are having is two fold: 1) The tran log on the primary server is not being truncated...
1
by: tram | last post by:
I have to schedule the automatic restore the standby database for testing backups . The database was already in log shipping mode. Up to what point do I need to restore the database without...
10
by: Howard Martin | last post by:
I have a form at http://www.develop.check.com.au/hh/order.html where an extended sub-total and then a grand total is calculated as soon as a quantity is input by a user. I would like to be able to...
2
by: nek | last post by:
Greetings, I tried to implement log shipping using PULL method as described in 'The Basics of DB2 Log Shipping' by Dale McInnis, but found the subsequent "rollforward" did not go beyond the...
2
by: Fred | last post by:
Hi. Sorry, but I don't know where else to ask. I wrote a access shipping database and we currently use the web interface for DHL to print shipping labels. That means we have to manualy transpose...
0
by: ppatel | last post by:
In shopping cart I have a Product Quantity and Unitcost per product. Should I calculate shipping (per item weight * Quantity) for each item or should I add up total weight and calculate shipping...
6
by: Chris Buckett | last post by:
Hi, I was just wondering if anyone has had any experience in developing a shipping matrix. We are based in the UK, and we need to ship both locally and internationally. Local shipping is...
2
by: studentofknowledge | last post by:
For some unknown reason ie is placing images I have in a div in a weird way. One image is overlapping another but this problem is not occuring in mozilla. I have looked at my code over and over again...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.