paul.knibbs (9/1/2011)
I'm still not sure this offers a major advantage! You're just moving the 50Gb of disk space usage from one place to another.
The log backup if you'd done the load in full recovery would also be around 50GB or more (the entire used log space would get backed up).
It's also a time advantage not just a space one. Less logging = less overhead = faster load.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability