Thursday, March 22, 2012

Best Practices for Moving SQL Server to Another domain?

I've been looking all over the KB trying to find documentation on Best
Practices for moving a SQL Server to another domain. What reACLing needs to
be done to the databases (if any) and what is the best way to do it?
Thanks for any links or help...
Here are a couple of Links...
http://support.microsoft.com/default...b;en-us;224071
http://support.microsoft.com/default...b;en-us;304692
Personally I would go for the first one, as it will transfer everything over.
Once completion do a sp_createstats & sp_updatestats
After than I would advise you run a performance trace for a about a week and
implement any changes, then run the sp_createstats & sp_updatestats again
Peter
"Denial ain't just a river in Egypt."
Mark Twain
"Losferwords" wrote:

> I've been looking all over the KB trying to find documentation on Best
> Practices for moving a SQL Server to another domain. What reACLing needs to
> be done to the databases (if any) and what is the best way to do it?
> Thanks for any links or help...
|||Let me be a little more specific... I'm moving a SQL Server from DOMAIN A to
DOMAIN B. Any Best Practices Guides on that?
"Losferwords" wrote:

> I've been looking all over the KB trying to find documentation on Best
> Practices for moving a SQL Server to another domain. What reACLing needs to
> be done to the databases (if any) and what is the best way to do it?
> Thanks for any links or help...
sql

No comments:

Post a Comment