The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog

 

Home

No Ads ever, except search!
Tuesday, October 19, 2021 Login
Public

Blog posts for the month of November,2017.
SQL Server Cluster Move - Check SPN11/16/2017 6:58:58 AM

Pretty common operation to migrate SQL Server from one cluster to another.

Generally it is advisable to build and test the new environment in advance, possibly even using replication and/or backup and restore with differential and tlogs to keep downtime to a very minimum when moving it.

There are a lot of little steps and i'm not going to document them, but one issue we recently ran into was an SPN on the old cluster was not "released / removed" from active directory when it was renamed and taken offline and online with the new name.  So... when we tried to bring the name online the new cluster it would not come online.

And of course the error message was not nice and clear like "Hey stupid, there is already an SPN in active directory with this name", no it wasn't, so it took me a good hour to find.

Also don't forget the properties of the cluster (virtual name is in there) and to sp_dropserver sp_addserver after rename.

Thanks to Vipin for helping find this !

 

Thomas First Deer - 201710/29/2017 10:25:28 AM

Thomas First Deer

Nice 8 point buck, 2 antlers a bit broke off, but well done job by a young hunter.

Rossi 243, trifecta.

These bucks have been stripping the trees around my property for years, probably the reason the only thing growing back there is hedge and locust !

 

Blog Home