Question

Christian2016 on Sun, 26 Feb 2017 15:05:52


All,

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?

- Chris


Sponsored



Replies

Alberto Morillo on Sun, 26 Feb 2017 15:20:49


Hello,

You need to use sysprep.

https://technet.microsoft.com/en-us/library/bb457067.aspx?f=255&MSPPError=-2147217396


Sysprep does not provide a unique name SQL Server name to SQL. This is by design and you may have to follow the steps provided on below article.

https://support.microsoft.com/en-us/help/303774/bug-renaming-a-server-topic-in-sql-server-books-online-is-incomplete



Hope this helps.



Regards,

Alberto Morillo
SQLCoffee.com




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


Hi Christian2016,

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.

Reference:
https://blogs.msdn.microsoft.com/virtual_pc_guy/2006/11/13/running-sysprep-on-a-virtual-machine-with-sql-server-installed/

Thanks,
Lydia Zhang