Thanks for the details. I am using linked server for accessing data from remote servers. But I wonder whether I need to handle the transactions manually, if I use linked...

Thank you for your reply.

I am not against the linked server usage. Actually i need to use it for my report creation from databases at the 3 different servers.

But...

:Wow: i got that

Yes, I need to load my daily data and create report. The users won't wait for my backup to complete:(. Also i had some limit for the data source and...

Thanks for a quick reply!!

Didn't get any error.:( The operation continued for almost 1 day after 90%. i don't have enough time to wait it to complete.

so I stopped it...

Please go through this:

http://msdn.microsoft.com/en-us/library/ms188055.aspx