We told you the benefits. No headaches when dealing with oddly named objects. That's it.

Since you're already using a batch file for the copy, I'd probably use it for the delete as well. Let me introduce you to an excellent batch file resource....

What level of granularity are you looking at? Hour, 30 minutes, 10 minutes, minute, second, millisecond, etc? While initially I didn't see a way it could be done without a...

Because it's not only reserved words (spaces in object names causes problems, for example), and because writing code to only put brackets around things that break the mold is more...

Also, isn't it master.sys.xp_delete_file for 2005, as opposed to dbo?

Yep, you're missing the "extension", which goes between the path and the datetime. Use the extension without the period, such as N'bak'

Since it's undocumented, I'm not sure, and it's been a while, but doesn't the date need to be an nvarchar datatype, instead of datetime? If not, I know there have...

By the way, the fact that you get duplicates means that you have some DBs that have either multiple Servers or multiple Members. While the DISTINCT takes care of it...

If that worked, and you didn't have nulls showing up before as defaults, then something was populating them with empty strings.

Add the indexes to the populated tables. If it takes more than a minute or two, I'd be surprised. A million records is nothing to SQL Server, as you'll find people...

Peter found at least one of the problems.

By the way, you're actually halfway there to debugging dynamic SQL, which is one of your complaints about it. That print statement you...

To make this easier, comment out the EXECUTE portion of this script at the bottom and then run it. If you don't get the error, then paste the results of...

XCOPY \\sourceserver\sourcevolume\sourcepath\sourcefilename \\destinationserver\destinationvolume\destinationpath\destinationfilename

You can use COPY instead of XCOPY, but I use XCOPY as it gives more switches that I may or may not need down the road.

Unless there are confidentiality reasons, I'd still recommend posting your code. Based on your error, I'm guessing it will be a lot more complex trying to debug it without the...

Then I'd personally go with the batch file. You can even call it from a job if you'd like.