That's a good point. I suppose I could put one together and that thought crossed my mind. In this case I wanted a solution that is independent of any external...

Maybe try to run PM on the box and see if there is something that is eating up resources when it happens.

We are kind of doing this already. There are tables with 130 million rows, 2.5 billion rows, etc. That would be impossible to blindly load without some change logic...

Thanks for the suggestions. We are using SSIS to load a data warehouse specifically for reporting purposes. I think every 30 min or so. The solution I was...

You understood correctly. Here is what my thought process was:

On subsequent passes replace original steps with "a" alternatives.

1. Set up log shipping from 1 to 2

1a. ship logs...

I found something that might be adapted to work in this situation... http://searchsqlserver.techtarget.com/tip/Tricking-SQL-Server-into-making-full-database-backups

I think if I can trick it to bring the db online and then run replication scripts...

I was thinking there could be a way to set this up with a third database/instance and have replication or something else set up between the log shipped database and...

That's too easy! 🙂 I was looking for something with a 5 minute update interval. Thanks for the reply though.

I know this is an old post, but in case anyone else is looking around for info about this error... It happened to me yesterday and I was able to...