I have a single SharePoint 2010 WFE with a single SQL 2005 64-bit backend. I need to decomission the SQL 2005 server. What is the best procedure to move all the SharePoint associated databases to SQL 2008 R2?
I have already read this MS doc on moving all databases:
So the actual move procedure is standard SQL fodder.
What I'm not clear about is what to do about the "other" SharePoint databases and how to reassociate them once the DBs are on the new SQL server. For example, the Usage and Health DB is going to "Wss_Logging" and it specifies my old SQL server.
It is greyed so I cannot chagne it in Central Admin. How do I let SharePoint know that these databases have been moved too?
View Complete Post