This question is being posted by the TechRepublic staff. The response(s) from this post may be turned into an article on the TechRepublic site. This is a winner-take-all scenario and the winner will be the person who provides the best and/or most complete answer in our judgment. If there are multiple correct answers we will select the one that was posted first. In addition to receiving a generous amount of TechPoints, the winner will get a free piece of TechRepublic gear (e.g., a coffee mug, a desk flag, or another item sporting the TechRepublic logo). This competition ends at 11:59 PM EDT on Sunday, May 30. Good luck and let the best techie win!
An organization’s SQL 7 server resides in one domain and holds a number of databases. The IT department now has to move those databases to a SQL 2000 server in another domain. What is the most foolproof and efficient way to accomplish the move?