Hi sqlfriends!

I have used backup/restore operations to transfer data before and found it to work well in certain circumstances. A 6GB backup/restore should be relatively quick however, I think it's important to get a little more information as there are a lot of different options out there. You said that the SSIS operation is using a lot of resources? Could you provide more detail on that? Have you identified a problem associated with it or just looking to improve the performance overall?

Thanks! 🙂