I would like to know if there are any dangers or relevant precautions before changing the IP address of a SQL Server 2008 R2 box.
We have a built a virtual PC with Windows Server 2008 R2 and SQL Server 2008 R2. The purpose of this machine is run a job that restores a backup file (copied by a different server), manipulates it, backs it up again and then copies it out to other servers. We've run it a few times in our test/dev DMZ and are now considering deployment.
The simplest option would be to re-IP it. The server name would remain intact. My problem is a colleague has suggested this is unsafe (to re-ip a SQL Server). My question is
a) Is this true for the OS and SQL I'm using? (Win 2008 R2 & SQL 2008 R2?)
b) Is it true for any other combinations of OS and/or SQL?
c) Is there anything special we should do in preparation?
My research thus far indicates it will be fine but I trust the folks of DBA StackExchange more than those social MSDN people.