Thanks all...
I've just done a count and the actual number of rows transferring will be about 3.5 - 4 million rows a day and about 4Gb.
Why do you expect using SSIS will avoid database log file growing?
I was thinking along the lines of when you do an export (ie right click on the DB, go to tasks, exports) that it doesn't fill the log files, so when transformed to an SSIS package it wouldn't either.... or is that a wrong assumption?
You will be better off with SELECT INTO and minimum logging using Simple or Bulk-logged mode
That was why I thought about doing a select into in the first instance, although I have to say I'm now thinking about the entire process in place where the iis log files get imported into the DB in the first place and that there might be a better way to manage the back ups than having to even transfer the data to a different database to back up.
Any thoughts on how to back up 1 days worth of data on a database daily rather than the whole lot every day?
Dh g gjhfvghhgfdfg