I'm planning to upgrade sql server 2005 to 2008. For now I'm just planning on it. If we use side by side upgrade, we will have to either copy data files to another server, or copy backup files to another server.
They are quite large size files. What are the best way to copy them? Currently, I only know manually use copy then paste to another \\serverB\$D\Data or \\serverB\$D\backup. Any other way of doing that for faster copy?