we plan to move our sql server from one place to another place. It's IP has
to been changed, yet the hostname can be kept. I need to access the possible
impact of this move. Our application server query the datababase by server
name. Apart from changing the DNS, what else I have to pay attention ?
Nothing. SQL Server needs to have the same hostname for replication, but
other than that, as far as I know there will be no impact from changing the
IP address.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LanLan" <LanLan@.discussions.microsoft.com> wrote in message
news:7E479E8D-ED7B-4D4F-8500-066C7B3C86CF@.microsoft.com...
> we plan to move our sql server from one place to another place. It's IP
> has
> to been changed, yet the hostname can be kept. I need to access the
> possible
> impact of this move. Our application server query the datababase by server
> name. Apart from changing the DNS, what else I have to pay attention ?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment