I'm at the point where I want to try to specify VMs for everything SQL. It's so much easier to add/remove CPUs/RAM as necessary and depending on how...

Right click the database in SQL2005, select EXPORT DATA under TASKS and follow The Wiz. This really just exports data, but if you select the target as a SQL2000...

You CAN export tables from SQL2005 to SQL2000. I just had to do that last week. May or may not give you the results you need.

Which backup job in particular? I only see one true backup job for BizTalk in our installation and it runs with the owner "sa".

Thanks folks,

I ended up using a file splitter program to split the backup file into pieces and let them reassemble it on the other end.

When I ran into that error, it was because xp_sendmail was looking for an AD logon id and not the e-mail user name.  Same person might have slightly different entries...