August 17, 2011 at 4:28 am
I've just had a call from one the network admins at my place of work that made my blood run cold.
I was told that all the SQL servers are going to move domain - I know little about how this is going to be done but can find out more.
Has anyone here had experience of moving a SQL box from one domain to another - if so how easy / problematic was it? Any "lessons learnt" from your experience? Or should I just say no?
Any advice / information greatly appreciated.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
August 17, 2011 at 5:03 am
Moving databases servers to new domains is quite common. Usually part of consolidating servers , Virtualization or even a data centre move.
Common things that go wrong are Firewalls and ports , user accounts authenticated at the domain need to be verified. Backup jobs that move file over the network are now unable to find destinations.
Usually these are planned well between the network guys and DBAs and a plan is made on which servers are the first to move and what kind of test need to be run to verify the enviornment is running properly. A part of this planning include what needs to be done if something goes wrong.
Application developers might need to verify if there are any code changes required because they are using environment specific features , such as timezone and locales etc.
There should be plenty of resources out there on what needs to be planned for a db migration.
August 17, 2011 at 10:34 am
sql server user accounts won't be affected but windows accounts including any service accounts may need to be addressed
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply