how can we migrate multiple databases of server 2000 to server 2005 spread across various servers in single shot. asked in an interview
Upgrades are done one of two ways, you upgrade the server itself, or you move the database through backup & restore or detach & attach. You can script the install of 2008 and fire the scripts off on multiple 2000 servers, but, it's likely to run into issues. The mitigation would be to run the Upgrade Advisor and fix any issues that this tool raises.
But, upgrading servers in place, is dangerous. Most of the upgrades I do, I use the backup & restore mechanism so that I can leave the 2000 server available in case there's a problem.
No one has followed this question yet.