Server: 1.25TB (6 disk RAID-5)

Desktop: 140GB (2 disk RAID-0) + 80GB

Laptop: 60GB

Asterisk: 8GB

What's the reason for doing it via a database backup, rather than a linked server (or something similar) copy?

Regardless, this approach won't work for us unfortunately - as I said...

Thanks for the info - DTS isn't my strong point.

Are the five steps you describe the actual five steps you'd add to the DTS package, or do they need to...

Dupe post, sorry.

Thanks for the linked server tip, will check it out. I'm not sure if it is available and can't check right now, but I now also have OPENROWSET/OPENDATASOURCE as backup...

Thanks for the tip on linked servers, OPENROWSET and OPENDATASOURCE - with that info I should think I can what I want to do with stored procedures.

Does OPENROWSET/OPENDATASOURCE require...

Hi guys,

Thanks for your help so far, really appreciate the responses.

Firstly, to clarify the volume of data - it is not that great. The two tables which are going...