I know you can backup site collections with
stsadm -o backup, and you can backup sites with
stsadm -o export. But what's the best way to copy a list? I've tried to use the save as a list template and include content, but not all the columns came across.
For example I had a lookup to another column in the same list but the data was totally messed up. only about 10% of the values were correct. I heard this is supposed to be available in 2010, but what's the best way to copy a list in 2007.