Christian2016 on Sun, 26 Feb 2017 15:05:52
will MS SQL Server 2000 (sic!) survive an image copy to a new virtual machine? Of course the image is taken when windows is shutdown. Is there any specialty I have to take care of?
Alberto Morillo on Sun, 26 Feb 2017 15:20:49
You need to use sysprep.
Hope this helps.
Christian2016 on Sun, 26 Feb 2017 16:19:08
Thank you. I will only use the new server and keep the old's name so this shouldn't be an issue, is it?
TiborK on Sun, 26 Feb 2017 16:22:29
If you keep the old machine name, then "SQL Server won't know what hit it". I.e., you should be fine. Assuming no replication, log shipping, or other dependencies (linked servers etc) on other machines that can mess you up, of course.
Christian2016 on Sun, 26 Feb 2017 20:49:13
no, it's just a standalone server. thanks again.
Lydia Zhang on Mon, 27 Feb 2017 08:13:16
You should be OK to clone SQL Server and you can keep old server name, just run the script in this KB article if you change server name.