We have an existing windows 2003 server with sql 2008 r2 enterprise. Its part of a Hyper-V configuration.
A new windows 2008 server was purchased. I need to move all databases, jobs and user accounts to the new server. We are staying with the same sql 2008 version. (The new server will also use Hyper-V)
I do not want to manually detach, copy/restore & attach each and very database and job to the new server. Additionally, I would like to keep the old production system online and roll over in a quick manner.
I did some reading and would like to hear from you experts which High Availability method would be good to move to the new system. (I have setup mirroring, log shipping and fail over clustering in lab enviroments in the past)
Additionally, I have another question (it may be out of context for this forum, but its very related to my first question).
I have a old widows server 2008 with sharepoint 2010, and sql 2008, this whole setup is also being moved to the new windows 2008 server. With all the info on the web, any pointers where to look will be very appreciated!
Thanks in advance!