Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Capt_Ron
Starting Member
45 Posts |
 Posted - 2008-11-10 : 09:39:50
|
| I have 2 sql servers SQL1, SQL2I'm replacing the hardware. The data and log drives are on a SAN so all I have to do is have the World Wide Names re-mapped to the new servers. (Real easy way of copying the data)My issue is this:I can't have servers with the same name on the network at the same time. So the new servers are SQL1New, SQL2New.Can I just create DNS entries for SQL1 and SQL2 that point to the new servers? I'll also be moving the SQL1 and SQL2 IP addresses to the new servers.Also how can I migrate all the security and maintenance plans?ThanksRon |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Capt_Ron
Starting Member
45 Posts |
Posted - 2008-11-10 : 11:41:45
|
| That's what we've been discussing.I've done that before and it's worked fine (after the stored procedures were run)It was juse mentioned to me to try the DNS thing. They want to migrate these again in 2009 to a cluster of 3 servers and they figured if we were using the DNS name redirects that it would be easier later.ThanksRon |
 |
|
|
|
|
|
Replacing Hardware