January 5, 2010 at 2:40 pm
im doing a migration project that involves moving 15 sql servers from an old ou to a new ou with new group policy defined. will this move affect sql servers and what pre-migration tests should i be looking at and if any what roll back steps would be required.
January 5, 2010 at 2:50 pm
This should be treated just like any other server move within your network. This is a network access issue, not a SQL Server one. As long as the new ou can be accessed by the existing users, you should be fine. So if the new ou is part of the same domain, or there is a trust relationship between domains, you should be OK.
As far as tests and rollbacks go, I would recommend setting up a test SQL box (or use one of your existing development boxes if possible) and migrate the box to the new ou. See what happens. If it does not work, migrate it back.
January 5, 2010 at 2:54 pm
John Rowan (1/5/2010)
This should be treated just like any other server move within your network. This is a network access issue, not a SQL Server one. As long as the new ou can be accessed by the existing users, you should be fine. So if the new ou is part of the same domain, or there is a trust relationship between domains, you should be OK.As far as tests and rollbacks go, I would recommend setting up a test SQL box (or use one of your existing development boxes if possible) and migrate the box to the new ou. See what happens. If it does not work, migrate it back.
Sound Advice.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 5, 2010 at 3:45 pm
thanks john, what is the process for migrating back if their are problems with new server in new ou. cheers
January 5, 2010 at 3:49 pm
Good question. I am not a network administrator so I don't know. I'd imagine that it is identical to moving it to the new ou. Isn't that just a drag/drop from within the AD admin tool? Again, I'm not a network admin, but I don't think moving objects between ou's within a domain is a very complex task.
January 5, 2010 at 4:09 pm
It is the same process. The reason you may run into problems is due to Policies that may or may not be place at the OU level. Another reason could be if you are moving to a new OU in a different domain and trust relationships are not properly setup.
As long as you are within the same domain, have the correct Policies configured at the new OU as were configured on the old OU, then you should be good to go.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 5, 2010 at 4:13 pm
group policy defined on the old out will will completly different to group policy defined at new out, cheers
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply