OK! That sounds great. But, to do inserts or BCP data I need to have thorough knowledge of relationships of parent & child tables in the database.

Unfortunately, I am strained with...

Fair, thanks for your input.

Any other thoughts from the forum?

Its clear from the error! Check your optimizations tab, and have the shrink database option disabled or change your backup schedule which wouldn't conflict with above shrinking operation.

OK. Thanks for the reply. I think I will recheck and get back to the forum.

OK. Thanks to all for your valuable feedback.

Let me mention another happening here.

I have a package B configured on a diff. instance "RAB" which extracts monitoring logs from all env....

Yes, the DTC services are up and running in the SQL Servers. This DTS package transfers some data from one environment to other. And we run this package thro' a...

Michelle

I second Ian's thoughts on BCP or Bulk Insert operation. Rebuilding of indexes does exactly as BCP does.

Why do you have such large growth of transaction log, is because...

I have an interesting setup based on your requirement. You may have to use SMTP Mail instead of MAPI.

I am not sure if you already got the solution as...

I would check the Event Viewer - System events in the server, to find the cause of the shutdown.